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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-47
SQL Item Descriptor Area of GET DESCRIPTOR
SQL Item Descriptor Area of GET DESCRIPTOR
Table 3-1 describes the items in the descriptor area for GET DESCRIPTOR. For
character fields with lengths greater than or equal to 128, declare the corresponding
host variables as type VARCHAR with length 129 (with an extra byte for the null
terminator) in C or type PIC X with length 128 in COBOL.
Table 3-1. GET DESCRIPTOR Items (page 1 of 4)
Name of Field Data Type and Description
CHARACTER_SET_NAME* Character string, minimum length >= 128. One, two, or
three-part name of the character set.
CHARACTER_SET_NAME Character string, minimum length >= 128. One-part character
set name.
CHARACTER_SET
_CATALOG
Character string, minimum length >= 128. Catalog part of the
character set name.
CHARACTER_SET
_SCHEMA
Character string, minimum length >= 128. Schema part of the
character set name.
COLLATION* Character string, minimum length >= 128. One, two, or
three-part name of the collation.
COLLATION_CATALOG Character string, minimum length >= 128. Catalog part of the
collation name.
COLLATION_NAME Character string, minimum length >= 128. One-part collation
name.
COLLATION_SCHEMA Character string, minimum length >= 128. Schema part of the
collation name.
DATETIME_CODE Exact numeric, scale 0.
Codes for datetime type: 1 date; 2 time; 3 timestamp. Codes
for interval subfields: 1 year; 2 month; 3 day; 4 hour; 5
minute; 6 second; 7 year to month; 8 day to hour; 9 day to
minute; 10 day to second; 11 hour to minute; 12 hour to
second; 13 minute to second.
This field is equivalent to the ANSI-named
DATETIME_INTERVAL_CODE field. You cannot use the
ANSI name for this field.**
HEADING* Character string, minimum length >= 128. Heading for
associated column.
* The statement item is an SQL/MX extension.
** The SQL/MX name is different from the ANSI name.