SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
3-52
SQL Descriptor Area Data Type Declarations of GET
DESCRIPTOR
134 _SQLDT_64BIT_S 64-bit signed (signed LARGEINT)
142 _SQLDT_IEEE_REAL 32-bit floating-point (IEEE REAL)
143 _SQLDT_IEEE_DOUBLE 64-bit floating-point (IEEE DOUBLE)
Decimal Data Types (150 – 156)
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)
155 _SQLDT_NUM_BIG_U Unsigned extended NUMERIC precision data
type
156 _SQLDT_NUM_BIG_S Signed extended NUMERIC precision data type
Date-Time and INTERVAL Data Types (192 – 212)
192 _SQLDT_DATETIME General Date-Time
195 _SQLDT_INT_Y_Y Year to Year
196 _SQLDT_INT_MO_MO Month to Month
197 _SQLDT_INT_Y_MO Year to Month
198 _SQLDT_INT_D_D Day to Day
199 _SQLDT_INT_H_H Hour to Hour
200 _SQLDT_INT_D_H Day to Hour
201 _SQLDT_INT_MI_MI Minute to Minute
202 _SQLDT_INT_H_MI Hour to Minute
203 _SQLDT_INT_D_MI Day to Minute
204 _SQLDT_INT_S_S Second to Second
205 _SQLDT_INT_MI_S Minute to Second
206 _SQLDT_INT_H_S Hour to Second
207 _SQLDT_INT_D_S Day to Second
208 _SQLDT_INT_F_F Fraction to Fraction
209 _SQLDT_INT_S_F Second to Fraction
210 _SQLDT_INT_MI_F Minute to Fraction
211 _SQLDT_INT_H_F Hour to Fraction
212 _SQLDT_INT_D_F Day to Fraction
Table 3-2. Descriptor Area Data Type Declarations (page 2 of 2)
Value Declaration in sqlci.h File Description