SQL/MP Programming Manual for COBOL

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
10-14
Defining Storage for Input and Output Parameters
VARCHAR Data Types (64 – 127)
64 Variable-length single-byte character
65 Variable-length single-byte character, upshifted
66 Variable-length double-byte character
Numeric Data Types (128 – 191)
130 16-bit signed (signed SMALLINT)
131 16-bit unsigned (unsigned SMALLINT)
132 32-bit signed (signed INT)
133 32-bit unsigned (unsigned INT)
134 64-bit signed (signed LARGEINT)
140 32-bit FLOAT (REAL)
141 64-bit FLOAT (DOUBLE PRECISION)
150 Unsigned DECIMAL
151 DECIMAL, leading sign separate (not SQL type)
152 DECIMAL, leading sign embedded
153 DECIMAL, trailing sign separate (not SQL type)
154 DECIMAL, trailing sign embedded (not SQL type)
Date-Time and INTERVAL Data Types (192 – 212)
192 General Date-Time (DATETIME)
195 Year to Year (INTERVAL)
196 Month to Month (INTERVAL)
197 Year to Month (INTERVAL)
198 Day to Day (INTERVAL)
199 Hour to Hour (INTERVAL)
200 Day to Hour (INTERVAL)
201 Minute to Minute (INTERVAL)
202 Hour to Minute (INTERVAL)
203 Day to Minute (INTERVAL)
204 Second to Second (INTERVAL)
205 Minute to Second (INTERVAL)
206 Hour to Second (INTERVAL)
207 Day to Second (INTERVAL)
208 Fraction to Fraction (INTERVAL)
209 Second to Fraction (INTERVAL)
Table 10-3. SQLDA DATA-TYPE Values (page 2 of 3)
Value Type of Data