SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-77
SET DESCRIPTOR Statement
SET DESCRIPTOR Statement
SQL Item Descriptor Area of SET DESCRIPTOR
Considerations for SET DESCRIPTOR
C Examples of SET DESCRIPTOR
COBOL Examples of SET DESCRIPTOR
The SET DESCRIPTOR statement changes specified information in an SQL descriptor
area. An application program can either set the count of item descriptors with
information or set the value of a specific field within a specific item.
Use SET DESCRIPTOR only in embedded SQL programs in C or COBOL.
descriptor-name
is a value-specification—a character literal or host variable with character
data type. The named SQL descriptor area must be currently allocated.
COUNT = value-specification
sets the COUNT of item descriptors from a value-specification—a literal with
exact numeric data type or a host variable. value-specification is the
number of dynamic parameters described in the descriptor area.
SET DESCRIPTOR descriptor-name {set-descriptor-info}
descriptor-name is:
[GLOBAL | LOCAL] value-specification
set-descriptor-info is:
COUNT = value-specification
| ROWSET_SIZE = value-specification
| VALUE item-number set-item-info [,set-item-info]...
set-item-info is:
descriptor-item-name = value-specification
descriptor-item-name is:
CHARACTER_SET_NAME
| DATETIME_CODE
| INDICATOR_DATA | INDICATOR
| INDICATOR_POINTER
| INDICATOR_TYPE
| LEADING_PRECISION
| LENGTH
| PRECISION
| ROWSET_IND_LAYOUT_SIZE
| ROWSET_VAR_LAYOUT_SIZE
| SCALE
| TYPE
| TYPE_FS
| VARIABLE_DATA | DATA
| VARIABLE_POINTER
C/COBOL