DBCHCL IRQ Function - Teradata Tools and Utilities

Purpose

IRQ (Initiate Request) sends a request to the database to be processed.

Usage Notes

• If Initiate Request is called without first calling CON, Initiate Request performs the CON. In this case, the information needed for a CON call should be supplied when doing the Initiate Request call.
• If Return Code is 0, the application must invoke the FET function to process the response. After the response has been totally processed, the application must invoke the ERQ function to release resources used by the Initiate Request.
• When initiating a request in a Two-phase commit session, Initiate Request is rejected if the session has a Two-phase commit vote or terminate activity in progress.
  • After they are started, activities such as vote and terminate must be completed by the coordinator.
  • The vote can result from a previous Initiate with Protocol-function (IWPF) function.
  • The terminate could have resulted from an Abort or Logoff or from any response that contained a Failure parcel.
  • If any of these occur, the coordinator must be requested to perform a syncpoint.

DBCAREA Input Fields

Before using the Initiate Request function, the application must set the DBCAREA fields in the first table and may optionally set those in the second table depending on the application's requirements.

DBCAREA Output Fields

Upon completion of the Initiate Request function, CLIv2 always sets DBCAREA fields in the first table and sets those in the second table if the function was successful.