Setting the Session Mode - Teradata Database

A system parameter specifies the default transaction mode for a site. You can override the default transaction processing mode for a session using one of the following:

SessionMode field of the DBS Control Record

BTEQ command .SET SESSION TRANSACTION

Preprocessor2 TRANSACT() option

Session Mode field of the Teradata ODBC Driver Options

JDBC TeraDataSource.setTransactMode() method

SQL Assistant when defining a .Net data source

Reference Information

Information on...	Is available in...
transaction, request, and statement processing transaction processing in ANSI and Teradata session modes	SQL Request and Transaction Processing
SQL statements for processing transactions: BEGIN TRANSACTION/END TRANSACTION COMMIT ABORT ROLLBACK	SQL Data Manipulation Language
setting the SessionMode field of the DBS Control Record	Utilities
using the SESSION TRANSACTION BTEQ command	Basic Teradata Query Reference
setting the Session Mode field in the Teradata ODBC Driver Options dialog box	ODBC Driver for Teradata User Guide
setting the Session Mode field when defining a .Net data source using SQL Assistant	Teradata SQL Assistant for Microsoft Windows User Guide