Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

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 once for each Db2 table being 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

Related topics

Function-codes-and-return-codes-for-UNLOAD-PLUS-user-exits

UNLOAD-PLUS-Assembler-user-exit

  

 

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