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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-50
SQL Descriptor Area Data Type Declarations of GET
DESCRIPTOR
SQL Descriptor Area Data Type Declarations of GET
DESCRIPTOR
The TYPE_FS field can have the values shown in Table 3-2. Use the declarations in
the sqlci.h header file for the TYPE_FS field in a C or C++ program. The sqlci.h
header file is automatically included in embedded SQL source files. Therefore, you can
use these declarations without adding #include directives.
TYPE_FS* Exact numeric, scale 0. These codes are SQL/MP-specific
codes returned in the SQL descriptor area, as shown under
SQL Descriptor Area Data Type Declarations of GET
DESCRIPTOR on page 3-50.
If you set TYPE_FS, you must also set LENGTH.
This field does not provide the ANSI codes for data type;
ANSI codes are provided by TYPE.
See Version Differences for TYPE and TYPE_FS
on
page 3-52.
UNNAMED Exact numeric, scale 0. Whether the associated select list
item is a named column. Codes: 1 unnamed; 0 named.
VARIABLE_DATA Actual data associated with the dynamic parameter. The type,
length, name, and so on, are determined by other fields.
This field is equivalent to the ANSI-named DATA field. You
can also use DATA as the name of the field.**
VARIABLE_POINTER* Pointer to the value of VARIABLE_DATA.
Table 3-2. Descriptor Area Data Type Declarations (page 1 of 2)
Value Declaration in sqlci.h File Description
Character Data Types (0 – 127)
0 _SQLDT_ASCII_F Fixed-length single-byte character
1 _SQLDT_ASCII_F_UP Fixed-length single-byte character, upshifted
2 _SQLDT_DOUBLE_F Fixed-length double-byte character
64 _SQLDT_ASCII_V Variable-length single-byte character
65 _SQLDT_ASCII_V_UP Variable-length single-byte character, upshifted
Numeric Data Types (128 – 134)
130 _SQLDT_16BIT_S 16-bit signed (signed SMALLINT)
131 _SQLDT_16BIT_U 16-bit unsigned (unsigned SMALLINT)
132 _SQLDT_32BIT_S 32-bit signed (signed INT)
133 _SQLDT_32BIT_U 32-bit unsigned (unsigned INT)
Table 3-1. GET DESCRIPTOR Items (page 4 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.