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 |