Usage Notes
The Change Options field specifies whether any options have been changed since the last time they were scanned by CLI.
Language | Variable Name |
---|---|
COBOL: | DBCAREA-CHANGE-OPTS |
C: DBCAREA.H: | change_opts |
Routine | Action Taken |
---|---|
DBCHINI: | writes |
DBCHCL: | reads (CON; RSUP; IRQ; FET; REW; ERQ; ABT) |
Used by | Action Taken |
---|---|
application program | writes |
Change Options is initialized by DBCHINI to the default value provided for Change Options in the site’s SPB.
If the value provided is not appropriate for the application, the application program may change the value. Options processing is expensive, so use it only when necessary. It may be necessary immediately after the call to DBCHINI to establish application-specific defaults. After that, it is only necessary if some processing option is changed.
Set Change Options to N after CLI picks up the new option settings. If Change Options is set to Y, DBCHCL uses the option flags that are appropriate for the value specified in function. The following table summarizes the option flags scanned for each function if Change Options is set to Y.
Options Scanned | Function | ||||||||
---|---|---|---|---|---|---|---|---|---|
Connect | Run Startup* | Initiate Request | Fetch | Rewind | End Request | Abort | Disconnect | Continue Request | |
columnInfo | No | Yes | Yes | No | No | No | No | No | No |
Connect Type | Yes | No | No | No | No | No | No | No | No |
Connect Wait | No | No | No | No | No | No | No | No | No |
Continuation Code | No | No | No | No | No | No | No | No | Yes |
Data Encryption | Yes | Yes | Yes | No | No | No | No | No | No |
Date Form | Yes | No | No | No | No | No | No | No | No |
Dynamic Result Sets Allowed | No | Yes | Yes | No | No | No | No | No | No |
Extended Load Usage | Yes | No | No | No | No | No | No | No | No |
Keep Response | Yes | Yes | Yes | No | No | No | No | No | No |
Language Conformance | Yes | No | No | No | No | No | No | No | No |
Locate Mode | Yes | Yes | Yes | No | No | No | No | No | Yes |
Maximum Integer Precision | No | Yes | Yes | No | No | No | No | No | No |
Maximum Parcel | Yes | Yes | Yes | No | No | No | No | No | Yes |
Multi-Statement-Errors | No | Yes | Yes | No | No | No | No | No | No |
Parcel Mode Fetch | Yes | Yes | Yes | No | No | No | No | No | Yes |
Period-as-Struct | No | Yes | Yes | No | No | No | No | No | No |
Positioning-action | No | No | No | Yes | No | No | No | No | No |
Positioning-statement-number | No | No | No | Yes | No | No | No | No | No |
Positioning-value | No | No | No | Yes | No | No | No | No | No |
Request Mode | No | No | Yes | No | No | No | No | No | Yes |
Request Processing Option | Yes | Yes | Yes | No | No | No | No | No | No |
Response Mode | Yes | Yes | Yes | No | No | No | No | No | No |
Return Identity Data | No | Yes | Yes | No | No | No | No | No | No |
Return Statement Info | No | Yes | Yes | No | No | No | No | No | No |
Return Time | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes |
Return Object | No | Yes | Yes | No | No | No | No | No | No |
Save Response Buffer | Yes | Yes | Yes | No | No | No | No | No | Yes |
Segment Data | No | Yes | No | No | No | No | No | No | No |
Set Character Set | Yes | Yes | Yes | No | No | No | No | No | No |
Statement-status | Yes | No | Yes | Yes | No | No | No | No | No |
Stored Procedure Return Result | No | Yes | Yes | No | No | No | No | No | No |
TASM FastFail Request | No | Yes | Yes | No | No | No | No | No | No |
Tell About Crash | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes |
Transaction Semantics | Yes | No | No | No | No | No | No | No | No |
Transforms-Off | No | Yes | Yes | No | No | No | No | No | No |
Trusted-request | No | Yes | Yes | No | No | No | No | No | No |
Two Response Buffer | Yes | Yes | Yes | No | No | No | No | No | No |
Use Presence Bits | Yes | Yes | Yes | No | No | No | No | No | No |
Utility Workload | Yes | No | No | No | No | No | No | No | No |
Variable Length Fetch | Yes | Yes | Yes | No | No | No | No | No | Yes |
Variable Length Request | Yes | Yes | Yes | No | No | No | No | No | Yes |
Wait Across Delay | Yes | Yes | Yes | No | Yes | Yes | Yes | No | Yes |
Wait For Response | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes |
xmlResponseFormat | No | Yes | Yes | No | No | No | No | No | No |