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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-78
SQL Item Descriptor Area of SET DESCRIPTOR
ROWSET_SIZE = value-specification
sets the length of rowsets specified in the item descriptors from
value-specification, a literal with exact numeric data type or a host variable.
value-specification is the common length of all rowsets described in the
descriptor.
VALUE item-number set-item-info [,set-item-info]...
sets the value of a specific field within a specific item. See SQL Item Descriptor
Area of SET DESCRIPTOR on page 3-78.
item-number
refers to a particular item in the SQL descriptor area. item-number must be
a host variable. The data type of item-number must be exact numeric, and its
value must be less than or equal to the maximum number of occurrences
specified when the SQL descriptor area was allocated. If item-number
exceeds the value of COUNT, a completion condition is raised (no data). See
ALLOCATE DESCRIPTOR Statement on page 3-6.
descriptor-item-name = value-specification
specifies the field descriptor-item-name in which to store the information
and the value-specification that is or contains the information—a literal
or a host variable.
SQL Item Descriptor Area of SET DESCRIPTOR
Table 3-5 describes the items in the descriptor area for SET DESCRIPTOR. For exact
numeric fields with scale 0, declare the corresponding host variables as type long in C
and PIC S9(9) COMP in COBOL. For character fields, declare the corresponding
host variables as type VARCHAR in C (with an extra byte for the null terminator) and
type PIX X in COBOL.