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:
- BTEQ command .SET SESSION TRANSACTION
- Preprocessor2 TRANSACT() option
- Session Mode field of the Teradata ODBC Driver Options
- JDBC TeraDataSource.setTransactMode() method
Related Information
| Topic | Resources |
|---|---|
| Transaction, request, and statement processing | SQL Request and Transaction Processing |
| Transaction processing in ANSI and Teradata session modes | Comparison of Transactions in ANSI and Teradata Session Modes |
| SQL statements for processing transactions | |
| Using the SESSION TRANSACTION BTEQ command | Basic Teradata® Query Reference, B035-2414 |
| Setting the Session Mode Field in the Teradata ODBC Driver Options dialog box | ODBC Driver for Teradata® User Guide, B035-2526 |