This statement is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
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 start with a BEGIN TRANSACTION statement, and you must specify both BEGIN TRANSACTION and END TRANSACTION statements to define the limits of an explicit transaction in Teradata session mode.
ANSI Compliance
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, the database aborts the request and returns an error.
For ANSI session mode transaction control statements, see COMMIT and ROLLBACK.
Required Privileges
None.