SessionOptions
Purpose
The SessionOptions parcel sets various options for a session.
Parcel Data
The following table lists field information for the SessionOptions parcel.
Flavor Field |
Parcel Body Length |
Parcel Body Fields |
||
114 |
10 |
|
Transaction Semantics: Mode: Language Conformance: DateForm: utilityWorkload: unused: |
type = CHAR(1) type = CHAR(1) type = CHAR(1) type = CHAR(1) type=CHAR(1) 5 bytes |
Field Notes
Semantics specifies the semantics to be used for requests within a transaction.
Valid settings are:
Setting |
Description |
D |
Default semantics |
T |
Teradata semantics |
A |
ANSI semantics |
Mode indicates that the system is in non-2PC Mode.
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).
The valid settings are:
Setting |
Description |
2 |
Two-phase commit (2PC) mode. |
N |
Non-2PC Mode. |
Conformance specifies whether or not SQL requests are to be checked for conformance with a particular language definition.
Valid settings are:
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. |
utilityWorkload specifies whether or not the proprietary CHECK WORKLOAD statement will be used.
Setting |
Description |
0 |
Proprietary CHECK WORKLOAD statement will not be used. |
1 |
Proprietary CHECK WORKLOAD statement will be used. |