SQL/MP Programming Manual for C

Converting C Programs
HP NonStop SQL/MP Programming Manual for C—429847-008
D-4
Generating a Version 2 SQLDA Structure
Example D-1 shows a version 2 SQLDA structure.
Table D-2 describes the fields in a version 2 SQLDA structure.
Example D-1. Version 2 SQLDA Structure
#define SQLDA_EYE_CATCHER "D1" /* can have _R2 appended */
struct SQLDA_TYPE /* can have _R2 appended */
{
char eye_catcher[2];
short num_entries;
struct SQLVAR_TYPE /* can have _R2 appended */
{
short data_type;
short data_len;
short precision;
short null_info;
long var_ptr;
long ind_ptr;
long long reserved;
} sqlvar[sqlvar-count];
} sqlda-name;
char names-buffer-name[ length + 1 ];
Table D-2. Version 2 SQLDA Structure Fields (page 1 of 2)
Field Name Description
eye_catcher
An identifying field that a program must initialize as D1 for version 1 or
DA for version 2. SQL/MP statements do not return values to
eye_catcher.
num_entries
Number of input parameters or output variables the SQLDA structure
can accommodate.
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 or output variables. For the table of data type
values, see Section 10, Dynamic SQL Operations
.