HP NonStop SQL/MP

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-10
SQLDA Structure, Names Buffer, and Collation
Buffer
Table 10-5 describes the declarations and values for the ranges of date-time and
INTERVAL data types for the SQLDA data_len field.
Table 10-5. SQLDA Date-Time and INTERVAL Declarations
Value Declaration Description
1 _SQL_DTINT_QUAL_Y_Y Year to Year
2 _SQL_DTINT_QUAL_MO_MO Month to Month
3 _SQL_DTINT_QUAL_D_D Day to Day
4 _SQL_DTINT_QUAL_H_H Hour to Hour
5 _SQL_DTINT_QUAL_MI_MI Minute to Minute
6 _SQL_DTINT_QUAL_S_S Second to Second
7 _SQL_DTINT_QUAL_F_F Fraction to Fraction
8 _SQL_DTINT_QUAL_Y_MO Year to Month
9 _SQL_DTINT_QUAL_Y_D Year to Day
10 _SQL_DTINT_QUAL_Y_H Year to Hour
11 _SQL_DTINT_QUAL_Y_MI Year to Minute
12 _SQL_DTINT_QUAL_Y_S Year to Second
13 _SQL_DTINT_QUAL_Y_F Year to Fraction
14 _SQL_DTINT_QUAL_MO_D Month to Day
15 _SQL_DTINT_QUAL_MO_H Month to Hour
16 _SQL_DTINT_QUAL_MO_MI Month to Minute
17 _SQL_DTINT_QUAL_MO_S Month to Second
18 _SQL_DTINT_QUAL_MO_F Month to Fraction
19 _SQL_DTINT_QUAL_D_H Day to Hour
20 _SQL_DTINT_QUAL_D_MI Day to Minute
21 _SQL_DTINT_QUAL_D_S Day to Second
22 _SQL_DTINT_QUAL_D_F Day to Fraction
23 _SQL_DTINT_QUAL_H_MI Hour to Minute
24 _SQL_DTINT_QUAL_H_S Hour to Second
25 _SQL_DTINT_QUAL_H_F Hour to Fraction
26 _SQL_DTINT_QUAL_S_S Second to Second
27 _SQL_DTINT_QUAL_S_F Second to Fraction
28 _SQL_DTINT_QUAL_F_F Fraction to Fraction