In most cases, use the vendor-provided statements for Beginning, Committing, or Rolling back transactions.
If you use ANSI Transaction mode with Teradata, the data connectivity tools auto-commit each statement. To create transactions in this mode, use the following SQL Assistant-specific commands:
| Command | Usage |
|---|---|
| .BeginTx | Starts a transaction |
| .CommitTx | Commits the transaction |
| .RollbackTx | Rolls back all changes made within the transaction |
If you attempt to disconnect or close the Query window while a transaction is in progress, it asks whether the transaction should be committed or rolled back.
Do not execute multiple queries at the same time within a single Query window while using transactions, unless the entire transaction is contained within a single query. Multiple queries execute within different sessions and there is no way to control which session executes which query.