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