Keep Response - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Keep Response

Usage Notes

The Keep Response field specifies whether or not the Teradata Database is to keep the spool file and repositioning information after it sends the last parcel of the Teradata SQL response to the client.

 

Language

Variable Name

COBOL:

DBCAREA-KEEP-RESP

C: DBCAREA.H:

keep_resp

 

Routine

Action Taken

DBCHINI:

writes

DBCHCL:

reads (CON; RSUP: IRQ)

 

Used by

Action Taken

application program

writes

Keep Response is initialized by DBCHINI to the default value provided for Keep Response in the site’s SPB.

If the value provided is not appropriate for the application, before calling DBCHCL for the Connect, Run Startup, or Initiate Request function, the application program may set:

  • Change Options to Y, and
  • Keep Response to:
  • Y, if the spool file is to be retained by the Teradata 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 Teradata 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 will 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.

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