Pseudo-SQLDA DSECT


This topic describes the Assembler exit 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 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:


major_assembler_user.png

  

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*