Purpose
The SessionOptions parcel sets various options for a session.
Parcel Data
Field information for the SessionOptions parcel is as follows:
| Flavor Field | Parcel Body Length | Parcel Body Fields | |
|---|---|---|---|
| 114 | 10 | Transaction Semantics: Mode: Language Conformance: DateForm: StatementStatus: CheckWorkload: Redrive: ExtendLoad unused: Reserved: |
1 byte character 1 byte character 1 byte character 1 byte character 1 byte character 1 byte character 1 byte character 1 byte character 1 byte 1 byte |
Field Notes
Semantics specifies the semantics to be used for requests within a transaction chosen as one of the following:
| Setting | Description |
|---|---|
| 'D' | Default semantics |
| 'T' | Teradata semantics |
| 'A' | ANSI semantics |
Mode specifies whether or not Two-phase commit is used for transactions in the session, chosen as one of the following:
| Setting | Description |
|---|---|
| '2' | Two-phase commit mode. |
| 'N' | Non-Two-phase commit mode. |
Conformance specifies whether or not SQL requests are to be checked for conformance with a particular language definition chosen as one of the following:
| Setting | Description |
|---|---|
| 'N' | No conformance. |
| '2' | ANSI entry-level (FIPS 127-2). |
| '3' | ANSI intermediate-level (FIPS 127-3). |
StatementStatus specifies the type of statement status parcels to be returned by the database, chosen as one of the following:
| Setting | Description |
|---|---|
| 'O' | Success, OK, Error, Failure, ErrorInformation, and StatementError parcels are returned. |
| 'E' | StatementStatus parcels may be returned. |
| 'D' | StatementStatus parcels, possibly with extensions identified as “descriptive” may be returned. |
CheckWorkload specifies whether the proprietary CHECK WORKLOAD statement will be used, chosen as one of the following:
| Setting | Description |
|---|---|
| 'O' | The proprietary CHECK WORKLOAD statement will not be used. |
| '1' | The proprietary CHECK WORKLOAD statement will be used. |
Redrive specifies whether or not a request for the session should be automatically redriven if the database restarts, chosen as one of the following:
| Setting | Description |
|---|---|
| 'N' | Requests interrupted by a database restart must be aborted, not redriven. |
| 'Y' | Requests interrupted by a database restart may be redriven. |
| binary zeroes | Requests that the database default for this action be used. |
ExtendedLoad specifies which of the Multiload utility proprietary protocols are supported by the utility, chosen as one of the following:
| Setting | Description |
|---|---|
| 'N' or '0' | Only the original Multiload protocol is supported. |
| 'Y' | Phase 1 protocol is supported by the application. |
| 'A' | Phase 1 protocol is required by the application. |
| '2' | Phase 2 protocol is supported by the application. |
| 'B' | Phase 2 protocol is required by the application. |