- Initiate with Protocol-function
- Initiate Request
When the value for Keep-response is not appropriate for the application, the application should perform the following procedure:
- Set Change-options to 'Y'.
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.