Using Transactions - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

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:





Starts a transaction


Commits the transaction


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.