Disable Transaction Commands
The disable_user_transactions hint lets you disable user transactions specified in one of the following ways:
Explicit commands for starting a transaction, such as BEGIN TRANSACTION (BT), BEGIN and other synonyms for the same SQL commands allowed by Teradata.
Implicit transactions formed by multi-statement requests such as:
“sql_statement1; sql_statement2;
Macro execution also results in multi-statement requests.
The disable_user_transactions hint does not disable transactions initiated by Hyper-Q as part of an emulation. For example, duplicate checks during the enforcement of uniqueness constraints. These rely on rollbacks to correctly implement the semantics.