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*