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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-79
SQL Item Descriptor Area of SET DESCRIPTOR
Table 3-5. SET DESCRIPTOR Descriptor Area Items (page 1 of 2)
Field Data Type and Description
CHARACTER_SET_NAME Character string. One-part character set 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.**
INDICATOR_DATA Exact numeric, scale 0. Value for the indicator variable of
VARIABLE_DATA:
0 INDICATOR_DATA is not null.
<0 INDICATOR_DATA is null.
>0 VARIABLE_DATA is truncated and INDICATOR_DATA is
the length of the source data.
This field is equivalent to the ANSI-named INDICATOR field.
You can also use INDICATOR as the name of the field.**
INDICATOR_TYPE* Exact numeric, scale 0. Type of INDICATOR_DATA. The
default type is short.
Values for INDICATOR_TYPE are:
-1 numeric data is negative
0 (optional) numeric data is positive
LEADING_PRECISION Exact numeric, scale 0. Precision of interval start field.
This field is equivalent to the ANSI-named
DATETIME_INTERVAL_PRECISION field. You cannot use the
ANSI name for this field.**
LENGTH Exact numeric, scale 0. Length (in characters) for strings.
OCTET_LENGTH Exact numeric, scale 0. Length in bytes for strings.
PRECISION Exact numeric, scale 0. Precision for numeric types.
PRECISION specifies the total number of digits and cannot
exceed 18.
ROWSET_IND_LAYOUT
_SIZE
Exact numeric, scale 0. Size of an individual array element in a
rowset host variable. A value 0 (zero) in this field denotes that
the host variable is not of rowset type and is a scalar host
variable.
ROWSET_VAR_LAYOUT
_SIZE
Exact numeric, scale 0. Size of an individual array element in a
rowset host variable. A value 0 (zero) in this field denotes that
the host variable is not of rowset type and is a scalar host
variable.
* The statement item is an SQL/MX extension.
** The SQL/MX name is different from the ANSI name.