17.10 - SessionOptions - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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:
  • Redrive:
  • extendedLoadUsage:
  • unused:
  • unused:
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)
  • type = CHAR(1)

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.

The valid settings are as follows:

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 as follows:

Setting Description
N No conformance.
2 ANSI entry-level (FIPS 127-2).
3 ANSI intermediate-level (FIPS 127-3).
FIPS 127-3 conformance is not supported by Teradata Database for UNIX release 2.0.

utilityWorkload specifies whether or not the proprietary CHECK WORKLOAD statement is used.

Setting Description
0 Proprietary CHECK WORKLOAD statement is not used.
1 Proprietary CHECK WORKLOAD statement is used.

Redrive enable/disable the Automatic Redrive and Recoverable Network Protocol (RNP) features.

Valid settings are as follows:

Setting Description
Y To enable RNP and Automatic-redrive
N To enable RNP and disable Automatic-redrive
E To disable RNP and Automatic-redrive
D To enable RNP and use the database setting for Automatic-redrive

extendedLoadUsage can specify if the traditional or extended Multiload protocol is used.

Valid settings are as follows:

Setting Description
Y It is available for the extended MultiLoad protocol.
N It is not available for the extended MultiLoad protocol.
A It is available for the extended MultiLoad protocol and it does not support the traditional MultiLoad protocol.
0 It is not available for the extended MultiLoad protocol for previous version (14.10) client.
2 It supports MLOADX Phase 2.
B It supports MLOADX Phase 2 and it does not support the traditional MultiLoad protocol.