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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-49
SQL Item Descriptor Area of GET DESCRIPTOR
PARAMETER_ORDINAL_
POSITION
Smallint. Indicates the position of a formal parameter in the
signature of a stored procedure that corresponds to a
described dynamic parameter. Values start at 1. A value of 0
(zero) means the position is undefined. For all SQL
statements other than the CALL statement,
PARAMETER_ORDINAL_POSITION is undefined.
PRECISION Exact numeric, scale 0. Precision for numeric types.
PRECISION specifies the total number of digits and cannot
exceed 18.
RETURNED_LENGTH Exact numeric, scale 0. Returned length in characters for
strings or in bytes for other data types.
RETURNED_OCTET
_LENGTH
Exact numeric, scale 0. Returned length in bytes.
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.
SCALE Exact numeric, scale 0. Scale for exact numeric types.
SCALE specifies the number of digits to the right of the
decimal point.
TYPE Exact numeric, scale 0.
ANSI codes for data type: 1 character; 2 numeric; 3 decimal;
4 integer; 5 smallint; 6 IEEE float; 7 IEEE real; 8 double
precision; 9 date, time, or timestamp; 10 interval; 12
character varying.
SQL/MX extensions: -101 character uppercase; -201 numeric
unsigned; -301 decimal unsigned; -302 decimal large; -303
decimal large unsigned; -401 integer unsigned; -402 largeint;
-411 Tandem float, -412 Tandem real, -413 Tandem double,
-502 smallint unsigned; -601 character varying with length
specified in first two bytes.
See Version Differences for TYPE and TYPE_FS
on
page 3-52.
Table 3-1. GET DESCRIPTOR Items (page 3 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.