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:
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.