Parameter fields for exit point QIBM_QZDA_ROI1 format ZDAR0200

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 ZDAR0200 format.

Table 1. Exit point QIBM_QZDA_ROI1 format ZDAR0200
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 ZDAR0200.
28 1C BINARY(4) Requested function The function being performed.
This field contains one of the following:
  • X'1809' - Retrieve foreign key information
  • X'180A' - Retrieve primary key information
32 20 CHAR(10) Primary key table schema name The name of the schema that contains the primary key table used when retrieving primary and foreign key information. When the name is greater than 10 bytes, the following special value will be passed, indicating that the primary key table schema name should be obtained from the ‘primary key table extended schema name' field:
  • *EXTDSCHMA
Note: The ‘Primary key table extended schema name' field will always be set,even if length is less than 10. Users can always refer to that field to get the schema name.
42 2A CHAR(128) Primary key table name (alias name) The name of the table that contains the primary key used when retrieving primary or foreign key information.
170 AA CHAR(10) Foreign key table schema name The name of the schema that contains the foreign key table used when retrieving foreign key information. When the name is greater than 10 bytes, the following special value will be passed, indicating that the foreign key table schema name should be obtained from the ‘foreign key table extended schema name' field:
  • *EXTDSCHMA
Note: The ‘Foreign key table extended schema name' field will always be set, even if length is less than 10. Users can always refer to that field to get the schema name.
180 64 CHAR(128) Foreign key table name (alias name) The name of the table that contains the foreign key used when retrieving foreign key information.
308 134 CHAR(128) Primary key table extended schema name The name of the schema that contains the primary key table used when retrieving primary key information
436 1B4 CHAR(128) Foreign key table extended schema name The name of the schema that contains the foreign key table used when retrieving foreign key information
Note: This format is defined by member EZDAEP in files H, QRPGSRC, QRPGLESRC, QCBLSRC and QCBLLESRC in library QSYSINC.