Using Transactions
In most cases, use the vendor provided statements for Beginning, Committing, or Rolling back transactions.
If you are using ANSI Transaction mode with Teradata, the data connectivity tools auto-commit each statement. In order 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.
Note: 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, because multiple queries execute within different sessions and there is no way to control which session executes which query.