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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-48
SQL Item Descriptor Area of GET DESCRIPTOR
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 was 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_POINTER* Pointer to the value of INDICATOR_DATA.
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 or in
bytes for other data types.
NAME Character string, minimum length >= 128. Name of the
associated column or name of the output parameter of a
stored procedure (if specified in the CREATE PROCEDURE
statement).
NULLABLE Exact numeric, scale 0. Whether the associated column is
nullable. Codes: 1 nullable; 0 not nullable.
For a dynamic parameter, NULLABLE is set to 1, indicating
that the dynamic parameter can have a null value.
OCTET_LENGTH Exact numeric, scale 0. Length in bytes for the field.
PARAMETER_MODE Smallint. Indicates whether the associated formal parameter
of the stored procedure was declared as IN, OUT, or, INOUT.
Four possible values:
0 PARAMETER_MODE_UNDEFINED
1 PARAMETER_MODE_IN
2 PARAMETER_MODE_OUT
4 PARAMETER_MODE_INOUT
The default value is 0 (zero), indicating that the parameter
mode is undefined. For all SQL statements other than the
CALL statement, PARAMETER_MODE is undefined.
Table 3-1. GET DESCRIPTOR Items (page 2 of 4)
Name of Field Data Type and Description
* The statement item is an SQL/MX extension.
** The SQL/MX name is different from the ANSI name.