The following table summarizes the options that scanned for each function if Change-options is set to ‘Y‘.
* These values are needed only for an implicit Connect.
Function | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Options Scanned | Connect | RunStartUp | Initiate Request | Initiate Within Protocol-function | Command | Continue-request | Rewind | End Request | Abort | Disconnect | Fetch |
Anticipated Num Sessions | no | yes* | yes* | yes* | yes | no | no | no | no | no | no |
APH-response-OK | no | yes | yes | yes | no | no | no | no | no | no | no |
Array-transforms-off | no | no | yes | yes | no | no | no | no | no | no | no |
Automatic-redrive | no | yes | yes | yes | yes | no | no | no | no | no | no |
Column-info | no | no | yes | yes | yes | no | no | no | no | no | no |
Connect-type | yes | no | no | no | no | no | no | no | no | no | no |
Continue-data | no | no | no | no | no | yes | no | no | no | no | no |
Continued-characters-state | no | yes | yes | yes | no | no | no | no | no | no | no |
Country-id | yes | no | no | no | no | no | no | no | no | no | no |
C2S-conversion | yes | yes | yes | yes | no | yes | no | no | no | no | no |
Data-encryption | no | yes | yes | yes | no | no | no | no | no | no | no |
Date-form | yes | no | no | no | no | no | no | no | no | no | no |
Delegate-user-identity | yes | no | no | no | no | no | no | no | no | no | no |
Extended-load | yes | yes* | yes* | yes* | no | no | no | no | no | no | no |
Inhibit-buffer-expansion | no | yes | yes | yes | yes | no | no | no | no | no | no |
Keep-response | no | yes | yes | yes | yes | no | no | no | no | no | no |
Language-conformance | yes | no | no | no | no | no | no | no | no | no | no |
Language-id | yes | no | no | no | no | no | no | no | no | no | no |
Large-row-support | yes | yes | yes | yes | no | no | no | no | no | no | no |
LOB-aggregate-data-pointer | no | no | yes | yes | no | no | no | no | no | no | no |
Locate-mode | yes | yes | yes | no | yes | yes | no | no | no | no | no |
Maximum-decimal-returned | no | yes | yes | yes | no | no | no | no | no | no | no |
Maximum-LOB-bytes-per-field | no | no | yes | yes | no | no | no | no | no | no | no |
Maximum-LOB-bytes-per-row | no | no | yes | yes | no | no | no | no | no | no | no |
Maximum-parcel | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Mechanism-data-encoding | yes | yes* | yes* | yes* | no | no | no | no | no | no | no |
Multi-statement-errors | no | no | yes | yes | yes | no | no | no | no | no | no |
Parameter-descriptor-length | no | no | yes | yes | no | no | no | no | no | no | no |
Parameter-descriptor-pointer | no | no | yes | yes | no | no | no | no | no | no | no |
Parcel-mode-fetch | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Period-as-struct | no | no | yes | yes | yes | no | no | no | no | no | no |
Positioning-action | no | no | no | no | no | no | no | no | no | no | yes |
Positioning-statement-number | no | no | no | no | no | no | no | no | no | no | yes |
Positioning-value | no | no | no | no | no | no | no | no | no | no | yes |
Protocol-function | no | no | yes | no | no | no | no | no | no | no | no |
Request-buffer-length | yes | yes* | yes* | yes* | no | no | no | no | no | no | no |
Refresh-cached-data | no | yes | yes | yes | no | no | no | no | no | no | no |
Request-mode | yes | yes | yes | yes | no | yes | no | no | no | no | no |
Request-parcel-format | yes | yes | yes | yes | no | no | no | no | no | no | no |
Request-processing-option | yes | yes | yes | yes | no | no | no | no | no | no | no |
Response-buffer-length | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Response-mode | yes | yes | yes | yes | yes | no | no | no | no | no | no |
Result-sets-OK | no | yes | yes | yes | no | no | no | no | no | no | no |
Return-identity-data | no | yes | yes | no | no | no | no | no | no | no | |
Return-objects-as | yes | yes | yes | yes | no | no | no | no | no | no | no |
Return-result-to | no | yes | yes | yes | no | no | no | no | no | no | no |
Return-statement-info | no | yes | yes | yes | no | no | no | no | no | no | no |
Return-time | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Row-count | no | yes* | yes | yes | yes | no | no | no | no | no | yes |
Save-response-buffer | yes | yes | yes | yes | no | yes | no | no | no | no | no |
Segment-data | yes | no | yes | yes | no | no | no | no | no | no | no |
Set-character-set | yes | yes | yes | yes | no | no | no | no | no | no | no |
Statement-status | yes | yes* | yes* | yes* | no | no | no | no | no | no | no |
S2C-conversion | yes | yes | yes | yes | no | yes | no | no | no | no | no |
Tell-if-delay | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Timing-precision | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Transaction-semantics | yes | no | no | no | no | no | no | no | no | no | no |
Transforms-off | no | no | yes | yes | yes | no | no | no | no | no | no |
Trusted-request | no | no | yes | yes | yes | no | no | no | no | no | no |
Two-phase commit | yes | no | no | no | no | no | no | no | no | no | no |
Two Response Buffer | yes | yes | yes | yes | no | no | no | no | no | no | no |
Use-default-conn | yes | yes* | yes* | yes* | no | no | no | no | no | no | no |
Use-presence-bits | yes | yes | yes | yes | yes | no | no | no | no | no | no |
Utility-workload | no | yes | yes | yes | yes | no | no | no | no | no | no |
Varying-length-fetch | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Varying-length-request | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Wait-during-delay | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
Wait-exclusion | yes | yes* | yes* | yes* | yes | no | no | no | no | no | no |
Wait-for-response | yes | yes | yes | yes | yes | yes | no | no | no | no | no |
XML-response-format | yes | yes | yes | yes | no | no | no | no | no | no | no |