SessionOptions - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

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.