Parameter fields for exit point QIBM_QZDA_SQL2 format ZDAQ0200
The following table shows parameter fields and their descriptions for the IBM® i database exit program called at exit point QIBM_QZDA_SQL2 with the ZDAQ0200 format.
Offset | Type | Field | Description | |
---|---|---|---|---|
Dec | Hex | |||
0 | 0 | CHAR(10) | User profile name | The name of the user profile that is calling the server. |
10 | A | CHAR(10) | Server identifier | The value is *SQLSRV for this exit point. |
20 | 14 | CHAR(8) | Format name | The user exit format name being used. For QIBM_QZDA_SQL1, the format name is ZDAQ0100. |
28 | 1C | BINARY(4) | Requested function | The function being performed. This field contains one of the following:
|
32 | 20 | CHAR(18) | Statement name | Name of the statement used for the prepare or execute functions. |
50 | 32 | CHAR(18) | Cursor name | Name of the cursor used for the open function. |
68 | 44 | CHAR(2) | Prepare option | Option used for the prepare function. |
70 | 46 | CHAR(2) | Open attributes | Option used for the open function. |
72 | 48 | CHAR(10) | Extended dynamic package name | Name of the extended dynamic package. |
82 | 52 | CHAR(10) | Package library name | Name of the library for extended dyanmic SQL package. |
92 | 5C | BINARY(2) | DRDA indicator |
|
94 | 5E | CHAR(1) | Commitment control level |
|
95 | 5F | CHAR(10) | Default SQL collection | Name of the default
SQL schema used by the IBM i
Database Server. If the actual default SQL schema name is greater
than 10 bytes, the following special value will be passed, indicating
that the default SQL schema name should be obtained from the ‘Extended
default SQL Schema' field:
|
105 | 69 | CHAR(1) | Naming Mode |
|
106 | 6A | CHAR(2) | Reserved | Reserved for future parameters. |
108 | 6C | BINARY(4) | Offset to the extended cursor name | The offset in this structure to the extended cursor name |
112 | 70 | BINARY(4) | Length of the extended cursor name | Length, in bytes, of the extended cursor name |
116 | 74 | BINARY(4) | Offset to the Extended Default SQL Schema | The offset in this structure to the Extended Default SQL Schema. |
120 | 78 | BINARY(4) | Length of the Extended default SQL Schema | Length, in bytes, of the Extended Default SQL Schema. |
124 | 7C | CHAR(110) | Reserved | Reserved for future parameters. |
234 | EA | BINARY(4) | SQL statement text length | Length of SQL statement text in the field that follows. The length can be a maximum of 2 MB (2,097,152 bytes). |
238 | EE | CHAR(*) | SQL statement text | Entire SQL statement. |
* | * | CHAR(*) | Extended Cursor Name | The extended cursor name. |
* | * | CHAR(*) | Extended Schema Name | The extended schema name. |
Note: This
format is defined by member EZDAEP in files H, QRPGSRC, QRPGLESRC,
QCBLSRC and QCBLLESRC in library QSYSINC.
|
The QIBM_QZDA_INIT exit point is defined to run an exit program at server initiation. If a program is defined for this exit point, it is called each time the database server is initiated.