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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-45
GET DESCRIPTOR Statement
GET DESCRIPTOR Statement
SQL Item Descriptor Area of GET DESCRIPTOR
SQL Descriptor Area Data Type Declarations of GET DESCRIPTOR
Considerations for GET DESCRIPTOR
C Examples of GET DESCRIPTOR
COBOL Examples of GET DESCRIPTOR
The GET DESCRIPTOR statement retrieves information from an SQL descriptor area.
An application program can either retrieve the count of item descriptors with
information or the value of a specific field within a specific item.
Use GET DESCRIPTOR only in embedded SQL programs in C or COBOL.
GET DESCRIPTOR descriptor-name get-descriptor-info
descriptor-name is:
[GLOBAL | LOCAL] value-specification
get-descriptor-info is:
variable-name = COUNT
| variable-name = ROWSET_SIZE
| VALUE item-number get-item-info [,get-item-info]...
get-item-info is:
variable-name = descriptor-item-name
descriptor-item-name is:
CHARACTER_SET_NAME
| CHARACTER_SET_NAME | CHAR SET
| CHARACTER_SET_CATALOG
| CHARACTER_SET_SCHEMA
| COLLATION
| COLLATION_CATALOG
| COLLATION_NAME
| COLLATION_SCHEMA
| DATETIME_CODE
| HEADING
| INDICATOR_DATA | INDICATOR
| INDICATOR_POINTER
| INDICATOR_TYPE
| LEADING_PRECISION
| LENGTH
| NAME
| NULLABLE
| OCTET_LENGTH
| PARAMETER_MODE
| PARAMETER_ORDINAL_POSITION
| PRECISION
| RETURNED_LENGTH
| RETURNED_OCTET_LENGTH
| ROWSET_IND_LAYOUT_SIZE
| ROWSET_VAR_LAYOUT_SIZE
C/COBOL