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

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-51
SQL Descriptor Area Data Type Declarations of GET
DESCRIPTOR
134 _SQLDT_64BIT_S 64-bit signed (signed LARGEINT)
140 _SQLDT_REAL 32-bit floating-point (Tandem REAL)
140 _SQLDT_TDM_REAL 32-bit floating-point (Tandem REAL)
141 _SQLDT_DOUBLE 64-bit floating-point (Tandem DOUBLE)
141 _SQLDT_TDM_DOUBLE 64-bit floating-point (Tandem DOUBLE)
142 _SQLDT_IEEE_REAL 32-bit floating-point (IEEE REAL)
143 _SQLDT_IEEE_DOUBLE 64-bit floating-point (IEEE DOUBLE)
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)
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