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.

Table 1. Exit point QIBM_QZDA_SQL2 format ZDAQ0200
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:

  • X'1800' - Prepare
  • X'1803' - Prepare and describe
  • X'1804' - Open/describe
  • X'1805' - Execute
  • X'1806' - Execute immediate
  • X'1809' - Connect
  • X'180C' - Stream fetch
  • X'180D' - Prepare and execute
  • X'180E' - Open and fetch
  • X'180F' - Create package
  • X'1810' - Clear package
  • X'1811' - Delete package
  • X'1812' - Execute or open
  • X'1815' - Return package information
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
  • 0 - Connected to local RDB
  • 1 - Connected to remote RDB
94 5E CHAR(1) Commitment control level
  • 'A' - Commit *ALL
  • 'C' - Commit *CHANGE
  • 'N' - Commit *NONE
  • 'S' - Commit *CS (cursor stability)
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:
  • *EXTDSCHMA
Note: The Extended Default SQL Schema field will always be set, even if length is less than 10. Users can always refer to that field to get the Default SQL Schema name.
105 69 CHAR(1) Naming Mode
  • '0' - SQL naming
  • '1' - System naming
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.