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.
- Change Options to 'Y'.
-
Change the Keep Response value 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.