16.20 - Using Transactions - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

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.