SQL/MP Programming Manual for C

Dynamic SQL Operations
HP NonStop SQL/MP Programming Manual for C—429847-008
10-5
SQLDA Structure, Names Buffer, and Collation
Buffer
Table 10-2 describes the C identifiers generated by an INCLUDE SQLDA directive.
Always use the symbolic names rather than the actual values because the values can
change in a new RVU.
Table 10-3 describes each field in a version 315 (or later) SQLDA structure.
Table 10-2. C Identifiers Generated by the INCLUDE SQLDA Directive
Name Value Description
SQLDA_EYE_CATCHER D1 Eye-catcher value. Use this identifier to
initialize the eye_catcher field in the
SQLDA structure:
strncpy(sqlda.eye_catcher,
SQLDA_EYE_CATCHER,2);
where sqlda is the name of the SQLDA
structure.
SQLDA_HEADER_LEN 4 The length in bytes of the SQLDA
structure header fields eye_catcher and
num_entries.
SQLDA_SQLVAR_LEN 24 The length in bytes of one SQLVAR entry.
SQLDA_NAMESBUF_OVHD_LEN 11 The overhead length in bytes added to the
names buffer. This overhead is the length
field (2 bytes), table name (8 bytes), and
period separator (1 byte).
Table 10-3. SQLDA Structure Fields (page 1 of 2)
Field Name Description
eye_catcher
An identifying field that a program must initialize. NonStop SQL/MP does
not return a value to eye_catcher.
num_entries
Number of input or output parameters the SQLDA structure can contain.
sqlvar
Group item that describes input parameters or database columns. The
DESCRIBE INPUT and DESCRIBE statements return one sqlvar entry
for each input parameter or each output variable.
data_type
Data type of the parameter. For the data_type values, see Table 10-4
on page 10-8.