SQL/MP Programming Manual for C

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-6
SQLDA Structure, Names Buffer, and Collation
Buffer
data_len
The value depends on the data type:
Fixed-length character Number of bytes in the string.
Variable-length character Maximum number of bytes in the string.
Decimal numeric Bits 0:7 specify the decimal scale.
Bits 8:15 specify the byte length of the item.
Binary numeric Bits 0:7 specify the decimal scale.
Bits 8:15 specify the byte length of the item (2,
4, or 8).
Date-time or INTERVAL Bits 0:7 specify the range of the field. For
these values, see Table 10-5
on page 10-10.
Bits 8:15 specify the storage size of the item.
precision
The precision value depends on the data type:
Binary numeric Numeric precision.
Date-time or INTERVAL Bits 0:7 specify the leading field precision.
Bits 8:15 specify the fraction precision.
If the FRACTION field is not included, bits 8:15 are 0.
Character and VARCHAR Character set ID. For the precision values,
see Table 10-5
on page 10-10.
null_info
For input parameters, null_info is a negative integer if the column
permits null values.
For output columns, null_info is a negative integer if the row returned
is null.
var_ptr
Extended address of the actual data (value of input parameter or
database column). NonStop SQL/MP does not return a value to
var_ptr. A program must initialize var_ptr to point to the input and
output data buffers.
ind_ptr
Address of a flag that indicates whether a parameter or column is null.
For input parameters, a program sets the ind_ptr location to –1 if the
user entered a null value.
For output columns, NonStop SQL/MP sets the ind_ptr location to –1 if
the column value is null.
A program that does not process null values should set ind_ptr to an
invalid address.
cprl_ptr
For input columns, cprl_ptr is not set.
For output columns, cprl_ptr contains the address of the collation
used by the column if a collation was used.
If a collation was not used for the output column, cprl_ptr contains a
negative integer.
Table 10-3. SQLDA Structure Fields (page 2 of 2)
Field Name Description