Exit program parameter formats

The exit points for native database and retrieving object information have two formats that are defined: QIBM_QZDA_SQL1 and QIBM_QZDA_SQL2. Depending on the type of IBM® i database function that is requested, one of the formats is used.

The QIBM_QZDA_SQL2 exit point is defined to run an exit point for certain SQL requests that are received for the database server. This exit point takes precedence over the QIBM_QZDA_SQL1 exit point. If a program is registered for the QIBM_QZDA_SQL2 exit point, it will be called, and a program for the QIBM_QZDA_SQL1 exit point will not be called.

Functions that cause the exit program to be called

  • Prepare
  • Open
  • Execute
  • Connect
  • Create package
  • Clear package
  • Delete package
  • Return package information
  • Stream fetch
  • Execute immediate
  • Prepare and describe
  • Prepare and execute or prepare and open
  • Open and fetch
  • Execute or open