16.20 - Changing the Value for Keep-response - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K
Keep-response is initialized by DBCHINI to the default value provided for Keep-response in the HSHSPB. When the value for Keep-response is not appropriate for the application, the application should perform the following procedure before calling DBCHCL for any of these functions:
  • RunStartUp
  • Initiate with Protocol-function
  • Command
  • Initiate Request

When the value for Keep-response is not appropriate for the application, the application should perform the following procedure:

  1. Set Change-options to 'Y'.
  2. Change the value for Keep-response as follows.
    If the spool file is to... Then change the value for Keep-response to...
    be retained by Teradata Database even after the last parcel of the Teradata SQL response has been sent to the client Y
    be discarded by Teradata Database after the last parcel of the Teradata SQL response has been sent N
    retain both the SQL response parcels and their original row locations so that the client may reposition the response directly to particular rows using Positioning-action P

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.

A call to DBCHCL for the Rewind function fails if Keep-response was N on the original request. Keep-response is not directly tied to Open-requests. Even if Keep-response is set to N and the last parcel has been sent so that Teradata Database discards the spool file, Open-requests is not decremented.

Applications must still call DBCHCL for the End Request function in order to decrement Open-requests and formally close the request, regardless of the setting of Keep-response, no matter how much of the response an application has been sent, and regardless of the actual state of the spool file.