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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-46
GET DESCRIPTOR Statement
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.
variable-name = COUNT
retrieves the count of item descriptors with information and stores the count in the
named host variable. COUNT is the number of input dynamic parameters or output
dynamic parameters (from a stored procedure or from select list columns)
described in the descriptor area.
variable-name = ROWSET_SIZE
retrieves the length of rowset variables specified in this descriptor descriptors and
stores the length in the named host variable. ROWSET_SIZE is the common
length of all input or output rowsets described in the descriptor area.
VALUE item-number get-item-info [,get-item-info ]...
retrieves the value of a specific field within a specific item. See SQL Item
Descriptor Area of GET DESCRIPTOR on page 3-47.
item-number
refers to a particular item in the SQL descriptor area. The data type of the item
number must be exact numeric, and its value must be less than the maximum
number of occurrences specified when the SQL descriptor area was allocated.
If the item number exceeds the value of COUNT, a completion condition is
raised (no data). See ALLOCATE DESCRIPTOR Statement on page 3-6.
variable-name = descriptor-item-name
specifies the host variable in which to store information and the field from
which to retrieve the information. The host variable must be of an appropriate
data type and size for the information being retrieved.
| SCALE
| TYPE | TYPE_FS
| UNNAMED
| VARIABLE_DATA | DATA
| VARIABLE_POINTER