Parameter fields for exit point QIBM_QZDA_ROI1 format ZDAR0100

The following table shows parameter fields and their descriptions for the IBM i database exit program called at exit point QIBM_QZDA_ROI1 using the ZDAR0100 format.

Table 1. Exit point QIBM_QZDA_ROI1 format ZDAR0100
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 For the database server the value is *RTVOBJINF.
20 14 CHAR(8) Format name The user exit format name being used. For the following functions, the format name is ZDAR0100.
28 1C BINARY(4)
Requested
function
 The function being performed.
This field contains one of the following:
  • X'1800' - Retrieve library information
  • X'1801' - Retrieve relational database information
  • X'1802' - Retrieve SQL package information
  • X'1803' - Retrieve SQL package statement information
  • X'1804' - Retrieve file information
  • X'1805' - Retrieve file member information
  • X'1806' - Retrieve record format information
  • X'1807' - Retrieve field information
  • X'1808' - Retrieve index information
  • X'180B' - Retrieve special column information
32 20 CHAR(20) Schema name The Schema or search pattern used when retrieving information about schemas, packages, package statements, files, members, record formats, fields, indexes, and special columns. If schema name length or search pattern length is greater than 20, the following special value will be passed, indicating that the schema name should be obtained from the ‘Extended Schema name' field:
  • *EXTDSCHMA
Note: The Extended schema name field will always be set, even if length is less than 20. Users can always refer to that field to get the schema name.
52 34 CHAR(36) Relational database name The relational database name or search pattern used to retrieve RDB information.
88 58 CHAR(20) Package name The package name or search pattern used to retrieve package or package statement information.
108 6C CHAR(256) File name (SQL alias name) The file name or search pattern used to retrieve file, member, record format, field, index, or special column information.
364 16C CHAR(20) Member name The member name or search pattern used to retrieve file member information.
384 180 CHAR(20) Format name The format name or search pattern used to retrieve record format information.
404 194 CHAR(256) Extended Schema Name Extended Schema name or search pattern used.
Note: This format is defined by member EZDAEP in files H, QRPGSRC, QRPGLESRC, QCBLSRC and QCBLLESRC in library QSYSINC.