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

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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.

    Result

    0

    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.