Changing the Value for Keep Response - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities
If the value provided is not appropriate for the application, perform the following steps before calling DBCHCL for the Connect, Run Startup, or Initiate Request function.
  1. Change Options to 'Y'.
  2. Change the Keep Response value to:
    • Y, if the spool file is to be retained by the database even after the last parcel of the Teradata SQL response has been sent to the client.
    • N, if the spool file is to be discarded by the database after the last parcel of the Teradata SQL response has been sent.
    • P, if the applications are to use cursor repositioning while fetching the response.

    A call to DBCHCL for the Rewind function does not fail if Keep Response is set to 'N' as long as all the parcels in the Teradata SQL response can fit in one response buffer.

    Always set keep_resp to 'N' while initiating a connect request.