Pseudo-SQLDA structure
struct SQLDA
{
CL8 sqldaid; /* ID */
int sqldabc; /* BYTE COUNT */
short sqln; /* TOTAL VARS */
short sqld; /* PERTINENT VARS */
#define SQLDSIZ 16 /* SIZE OF FIXED PART */
};
#define SQLD sqld
#define SQLDABC sqldabc
#define SQLDAID sqldaid
#define SQLN sqln
#define SQLVAR sqlvar[0]
/*
SYMBOL OFFSET SIZE TYPE C-TYPE C-NAME
SQLD 00000E 000002 H short sqld
SQLDA 000000 000000
SQLDABC 000008 000004 F int sqldabc
SQLDAID 000000 000008 CL8 CL8 sqldaid
SQLN 00000C 000002 H short sqln
SQLVAR 000010 000000 0F int [0] sqlvar
*/
{
CL8 sqldaid; /* ID */
int sqldabc; /* BYTE COUNT */
short sqln; /* TOTAL VARS */
short sqld; /* PERTINENT VARS */
#define SQLDSIZ 16 /* SIZE OF FIXED PART */
};
#define SQLD sqld
#define SQLDABC sqldabc
#define SQLDAID sqldaid
#define SQLN sqln
#define SQLVAR sqlvar[0]
/*
SYMBOL OFFSET SIZE TYPE C-TYPE C-NAME
SQLD 00000E 000002 H short sqld
SQLDA 000000 000000
SQLDABC 000008 000004 F int sqldabc
SQLDAID 000000 000008 CL8 CL8 sqldaid
SQLN 00000C 000002 H short sqln
SQLVAR 000010 000000 0F int [0] sqlvar
*/
The pseudo-SQLDA structure consists of two portions:
- The first portion of the pseudo-SQLDA structure contains the fields of the SQLDA. This portion appears after each Db2 table is unloaded.
The second portion of the pseudo-SQLDA structure contains the fields of the SQLVAR. This portion is repeated for each column in the Db2 table being unloaded.
Within the SQLVAR portion of the pseudo-SQLDA structure is a field for the SQLTYPE. The value of this field depends on the type of data in the column and whether or not it allows null values.
The tables in UNLOAD PLUS pseudo-SQLDA summarize the field information for this structure.
The following figure illustrates the LE C user exit pointer parameter control block relationships:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*