SQL/MP Programming Manual for C

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-8
SQLDA Structure, Names Buffer, and Collation
Buffer
Using Declarations for the SQLDA Structure
HP provides declarations in the sqlh file that you can use for the SQLDA data_type
and precision fields. Use the #include directive to copy these declarations into a
C program. Table 10-4 describes the declarations and values for the SQLDA
data_type field.
Table 10-4. SQLDA Data Type Declarations (page 1 of 2)
Value Declaration 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
66 _SQLDT_DOUBLE_V Variable-length double-byte character
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)
134 _SQLDT_64BIT_S 64-bit signed (signed LARGEINT)
140 _SQLDT_REAL 32-bit floating point (REAL)
141 _SQLDT_DOUBLE 64-bit floating point (DOUBLE
PRECISION)
Decimal Data Types (150 – 154)
150 _SQLDT_DEC_U Unsigned DECIMAL
151 _SQLDT_DEC_LSS DECIMAL, leading sign separate (not SQL
type)
152 _SQLDT_DEC_LSE ASCII DECIMAL, leading sign embedded
153 _SQLDT_DEC_TSS DECIMAL, trailing sign separate (not SQL
type)
154 _SQLDT_DEC_TSE DECIMAL, trailing sign embedded (not
SQL type)