END TRANSACTION - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

Defines the completion of an explicit Teradata session mode transaction, commits the transaction, and drops its Transient Journal.

An explicit Teradata session mode transaction must always start with a BEGIN TRANSACTION statement, and you must always specify both BEGIN TRANSACTION and END TRANSACTION statements to define the limits of an explicit transaction in Teradata session mode.

See “BEGIN TRANSACTION” on page 284 for additional usage information about END TRANSACTION.

END TRANSACTION is a Teradata extension to the ANSI SQL:2011 standard.

The statement is valid only in Teradata session mode. If you submit an END TRANSACTION statement in ANSI session mode, Teradata Database aborts the request and returns an error.

For ANSI session mode transaction control statements, see “COMMIT” on page 318 and “ROLLBACK” on page 462.

None.

When you code an explicit transaction in Teradata session mode, you must initiate the transaction with a BEGIN TRANSACTION statement (see “BEGIN TRANSACTION” on page 284) and complete it with an END TRANSACTION statement.

There can be no more than one END TRANSACTION statement specified in a multistatement request, and that statement, if specified, must be the last statement in the request.

While an END TRANSACTION request terminates and commits a transaction and drops its Transient Journal, ABORT and ROLLBACK requests terminate a transaction with rollback (see “ABORT” on page 277 and “ROLLBACK” on page 462).

In general, the rules for committing transactions using the COMMIT statement (see “COMMIT” on page 318) also apply to END TRANSACTION.

The following rules apply to the use of END TRANSACTION in embedded SQL.

  • END TRANSACTION is valid only when you specify the TRANSACT(BTET) or ‑tr(BTET) options to the preprocessor. Otherwise, an error is returned and the precompilation fails.
  • END TRANSACTION cannot be performed as a dynamic SQL statement.
  • When END TRANSACTION is processed, the transaction, if not already aborted, is committed.
  • “ABORT” on page 277
  • “BEGIN TRANSACTION” on page 284.
  • “COMMIT” on page 318
  • “ROLLBACK” on page 462