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. |