Transaction Processing in Teradata Session Mode
A Teradata SQL transaction can be a single Teradata SQL statement, or a sequence of Teradata SQL statements, treated as a single unit of work.
Each request is processed as one of the following transaction types:
An implicit transaction is a request that does not include the BEGIN TRANSACTION and END TRANSACTION statements. The implicit transaction starts and completes all within the SQL request: it is self-contained.
An implicit transaction can be a:
DDL statements are not valid in a multistatement request and are therefore not valid in an implicit multistatement transaction.
In Teradata session mode, an explicit transaction contains one or more statements enclosed by BEGIN TRANSACTION and END TRANSACTION statements. The first BEGIN TRANSACTION initiates a transaction and the last END TRANSACTION terminates the transaction.
When multiple statements are included in an explicit transaction, you can only specify a DDL statement if it is the last statement in the series.
2PCprotocol is supported in Teradata session mode: