ANSI Mode Transactions - Analytics Database - Teradata Vantage

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢
An ANSI mode transaction is implicitly opened by either of the following events:
  • Execution of the first SQL request in a session.
  • Execution of the first request following the close of a previous transaction.

Transactions close when the application performs a COMMIT, ROLLBACK, or ABORT request.

When the transaction contains a DDL statement (including DATABASE and SET SESSION, which are considered DDL statements in this context), the statement must be the last request in the transaction before the transaction closing statement.

A session executing under ANSI transaction semantics does not allow the BEGIN TRANSACTION statement, END TRANSACTION statement, or two-phase commit protocol. Submitting these statements in ANSI mode is an error.

In ANSI mode, the system rolls back the transaction if the current request does any of the following:
  • Results in a deadlock.
  • Performs a DDL statement that stops.
  • Executes an explicit ROLLBACK or ABORT statement.

Vantage accepts the ABORT and ROLLBACK statements (including their conditional forms) in ANSI mode. If the system detects an error for either a single or multistatement request, it rolls back only that request, and the transaction remains open, except in special circumstances.

Application-initiated, asynchronous stops cause full transaction rollback in ANSI mode.