set descriptor

Description

Inserts or updates data in a SQL descriptor.

For a list of possible SQL descriptor datatypes, see Table 10-5.

Syntax

exec sql set descriptor descriptor_name 
 {count = host_variable} | 
 {value item_number {item_name = 
  :host_variable}[,...];

Parameters

descriptor_name

The name of the SQL descriptor that contains information about the dynamic parameter markers in a prepared statement.

count

The number of dynamic parameter specifications to be described.

host_variable

A host variable defined in a declare section.

item_number

Represents the nth occurrence of either a dynamic parameter marker or a select column.

item_name

Represents the attribute information of either a dynamic parameter marker or a select list column. Table 10-4 lists the values for item_name.

Table 10-4: Values for item_name

Value

Description

data

Value for the dynamic parameter marker or target associated with the specified SQL descriptor. If indicator is negative, this field is undefined.

length

The length, in characters, of the dynamic parameter marker of target for the specified SQL descriptor.

precision

An integer specifying the total number of digits of precision for the CS_NUMERIC variable.

scale

An integer specifying the total number of digits after the decimal point for the CS_NUMERIC variable.

type

The datatype of this column (item number) in the row. For values, see Table 10-5.

Examples

Example 1

exec sql prepare get_royalty
     from "select royalty from roysched
     where title_id = ? and lorange <= ? and 
     hirange > ?";

exec sql allocate descriptor roy_desc with max 3;
exec sql set descriptor roy_desc
     value 1 data = :tid;
 exec sql set descriptor roy_desc
     value 2 data = :sales;
 exec sql set descriptor roy_desc
     value 3 data = :sales;
exec sql execute get_royalty into :royalty
     using sql descriptor roy_desc;

Usage

See also

allocate descriptor, describe input, describe output, execute, fetch, get descriptor, open(dynamic cursor)