Changing the Value for Request-processing-option - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities
When the value for Request-processing-option is not appropriate for the application, you should perform the following procedure before calling DBCHCL for the Connect, RunStartUp, Command, Initiate with Protocol-function, or Initiate Request function:
  1. Set Change-options to 'Y'.
  2. Change Request-processing-option as follows:
    If the database is to... Then change the value for Request-processing-option to...
    execute the request and send back the returned data E
    analyze each statement in the request. The statements may not contain parameterized SQL.

    If the request is valid, the database returns a time estimate and format information about the data that it would return if the request were executed.

    Note that the time estimate is the same as EXPLAIN returns.

    P
    analyze each statement in the request. The statements may contain parameterized SQL. If the request is valid, the database returns a time estimate and format information about the data that would be returned if the request were executed. The time estimate is the same as EXPLAIN returns. S
    analyze each statement in the request, then execute the request. The statements may contain parameterized SQL. If the request is valid, the database returns not only a time estimate and format information about the data returned, but also the data resulting from the executed request. Note that the time estimate is the same as EXPLAIN returns. B

The difference between "P" and "S" is that "P" does not support parameterized SQL while "S" does.

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.

If the request is not valid, the database returns an Error, StatementError, or Failure parcel, the same as if Request-processing-option is set to E.

If "S" or "B" is specified but the database does not support that option, a Failure parcel with error code 3749 will be returned.

Request-processing-option is read by the call to DBCHCL for the Connect function and stored in the appropriate control blocks but is not used during the connect.