15.10 - Continuing a Teradata SQL Request - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Call-Level Interface Version 2
Programming Reference

When an ElicitData, ElicitDataByName, or ElicitFileresponse parcel is fetched, Teradata Database requires additional information to complete the request. To provide that information, an application must perform the following steps:

1 Modify the DBCAREA.

a Set the Function to 15 (ContinueRequest).

b Set the Input CLIv2 Session Id to the Output CLIv2 Request Id returned when the session was established.

c Set the Input CLIv2 Request Id to the Output CLIv2 Request Id returned when the request was initiated.

d Set the Request Pointer field.

e Set the Request Length field.

f Optionally set the following fields:

  • Fetch Buffer Length field
  • Message Area Pointer field
  • Message Area Length field
  • g Optionally set the Change Options option to 'Y', and set the following:

  • C2S Conversion option
  • Locate Mode option
  • Maximum Parcel option
  • 2 Call DBCHCL to perform the ContinueRequest function.

    3 Check the return code from DBCHCL:


    Return Code.



    Call DBCHCL to perform a Fetch function to get the final status of the rewind and the first part of the response. For more information, see “Fetching the Response for a Request” on page 58.

    anything else

    Process the return code and DBCAREA message.

    4 Call DBCHCL to perform the End Request function. For more information, see “Ending a Request” on page 60.