SQLDA

typedef struct sqlda;

{

unsigned char sqldaid [8];

int sqldabc;

short sqln;

short sqld;

struct sqlvar sqlvar [1];

}

SQLDA;

 

The SQLDA is a structure that defines a multi-column file.

 

SQLDA variables and fields

An SQLDA consists of four variables (sqldaid, sqldabc, sqln and sqld), followed by an arbitrary number of SQLVARs.

 

SQLDA Variable

Description

sqldaid

8 byte character field containing an eye catcher for use in storage dumps.

An SQLDA dynamically allocated by a call to SAGQPREP will contain the 7 byte reserved value 'SQLDADA' which must NOT be modified by the application. The 8th byte of the field may be modified by the application if required.

A static SQLDA previously allocated by the application can contain any value except for 'SQLDADA*'.

sqldabc

4 byte integer field containing the length of the SQLDA. Not required.

sqln

2 byte integer field containing the total number of occurrences of SQLVAR.

sqld

2 byte integer field containing the number of columns described by occurrences of SQLVAR.