- Change Options to 'Y'.
- Set the Request Processing Option value to:
E, if the database is to execute the request in the request string and send back the returned data,
P, if the database is to analyze the request in the request string, and if:
Request is valid, send back a time estimate and format information about the data that it would return if the request were executed (the time estimate is the same as EXPLAIN returns)
Request is invalid, send back an Error or Failure parcel (the same as if Request Processing Option is set to E).
S, 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.
The difference between the P and S mode is that P mode cannot contain a parameterized SQL request.
B, analyze each statement in the request, then execute the request. The statements may contain parameterized SQL. If the request is valid, the database does return not only a time estimate and format information about the data that would be returned if the request were executed, but also the data resulting from the executed request. The time estimate is the same as EXPLAIN returns.
B option is supported both in buffer and parcel modes.
Segmented requests (TDSP) are not supported in S, B, and P modes. If these requests are submitted in either the S, B or P modes, the database returns a failure parcel with the error code set to 3749.
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 options:
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.