Parcel Data
Table 30 provides field information for the SessionOptions parcel.
|
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 (2PC) mode. |
|
'N' |
Non-2PC Mode. |
Note: Two-phase commit is available only for Teradata Database for UNIX version 2 release 2 (or later), and for Teradata DBS for TOS version 1 release 5 (or later).
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). Note: FIPS 127-3 conformance is not supported by the Teradata Database for UNIX release 2.0. |
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 indentified 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. |