Pseudo-SQLDA DSECT
** MACRO GENERATED SQLDA AREA SAME AS EXEC SQL INCLUDE SQLDA
*
* THE SQLDA AREA IS ALSO UNIQUE FOR EACH INVOCATION OF THE EXIT.
* ANY MODIFICATIONS MADE TO DATA IN THIS AREA ARE NOT SHARABLE
* AMONG TASKS IN A MULTITASKING ENVIRONMENT.
*
SQLDA DSECT
SQLDAID DS CL8 ID
SQLDABC DS F BYTE COUNT
SQLN DS H TOTAL VARS
SQLD DS H PERTINENT VARS
SQLVAR DS 0F BEGIN VARS
SQLDSIZ EQU *-SQLDA SIZE OF FIXED PART
SQLVARN DSECT , NTH VARIABLE
SQLTYPE DS H TYPE CODE
SQLLEN DS 0H NAME LENGTH
SQLPRCSN DS X DEC PRECISION
SQLSCALE DS X DEC SCALE
SQLDATA DS A ADDR OF DATA IN OUTPUT RECORD
SQLIND DS A ADDR OF NULL FIELD BYTE (? IF NULL)
SQLNAME DS H,CL30 DESCRIBE NAME
ORG SQLNAME
SQLNAM$ DS H SIZE OF COL NAME
SQLNAM DS CL30 NAME ALONE
SQLVSIZ EQU *-SQLVARN
*
* THE SQLDA AREA IS ALSO UNIQUE FOR EACH INVOCATION OF THE EXIT.
* ANY MODIFICATIONS MADE TO DATA IN THIS AREA ARE NOT SHARABLE
* AMONG TASKS IN A MULTITASKING ENVIRONMENT.
*
SQLDA DSECT
SQLDAID DS CL8 ID
SQLDABC DS F BYTE COUNT
SQLN DS H TOTAL VARS
SQLD DS H PERTINENT VARS
SQLVAR DS 0F BEGIN VARS
SQLDSIZ EQU *-SQLDA SIZE OF FIXED PART
SQLVARN DSECT , NTH VARIABLE
SQLTYPE DS H TYPE CODE
SQLLEN DS 0H NAME LENGTH
SQLPRCSN DS X DEC PRECISION
SQLSCALE DS X DEC SCALE
SQLDATA DS A ADDR OF DATA IN OUTPUT RECORD
SQLIND DS A ADDR OF NULL FIELD BYTE (? IF NULL)
SQLNAME DS H,CL30 DESCRIBE NAME
ORG SQLNAME
SQLNAM$ DS H SIZE OF COL NAME
SQLNAM DS CL30 NAME ALONE
SQLVSIZ EQU *-SQLVARN
The pseudo-SQLDA DSECT consists of two portions:
- The first portion of the pseudo-SQLDA DSECT contains the fields of the SQLDA. This portion appears after each Db2 table is unloaded.
The second portion of the pseudo-SQLDA DSECT contains the fields of the SQLVAR. This portion will be repeated for each column in the Db2 table being unloaded.
Within the SQLVAR portion of the pseudo-SQLDA, DSECT 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 displays the Assembler parameter control block relationships:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*