SQL/MP Programming Manual for COBOL85

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
10-12
Defining Storage for Input and Output Parameters
DATA-LEN The DATA-LEN value depends on the data type as follows:
Fixed-length character The number of bytes in the string.
Variable-length character The maximum number of bytes in the string.
Decimal numeric Bits 0:7 contain the decimal scale. Bits 8:15
contain the byte length of the item.
Binary numeric Bits 0:7 contain the decimal scale. Bits 8:15
contain the byte length of the item (2, 4, or 8).
Date-time or INTERVAL Bits 0:7 contain one of these codes for the
range of the field. Bits 8:15 contain the storage
size of the item.
1 Year to Year 11 Year to Minute 20 Day to Minute
2 Month to Month 12 Year to Second 21 Day to Second
3 Day to Day 13 Year to Fraction 22 Day to Fraction
4 Hour to Hour 14 Month to Day 23 Hour to Minute
5 Minute to Minute 15 Month to Hour 24 Hour to Second
6 Second to Second 16 Month to Minute 25 Hour to Fraction
7 Fraction to Fraction 17 Month to Second 26 Minute to Second
8 Year to Month 18 Month to Fraction 27 Minute to Fraction
9 Year to Day 19 Day to Hour 28 Second to
Fraction
10 Year to Hour
PRECISION The PRECISION value depends on the data type as follows:
Binary numeric The numeric precision.
Date-time or INTERVAL Bits 0:7 contain the leading field precision.
Bits 8:15 contain the fraction precision. If the
FRACTION field is not included, bits 8:15
are 0.
Character and VARCHAR The character set ID as follows
(0 = UNKNOWN):
1 KANJI 101 ISO88591 104 ISO88594 107 ISO88597
12 KSC5601 102 ISO88592 105 ISO88595 108 ISO88598
103 ISO88593 106 ISO88596 109 ISO88599
NULL-INFO For input parameters, NULL-INFO contains a negative integer if the
parameter permits null values.
For output parameters, NULL-INFO contains a negative integer if the
parameter can return a null value.
Table 10-2. SQLDA Structure Fields (page 2 of 3)
Field Name Description