Teradata Transaction Semantics
Two modes of transactions are available:
If you are using Teradata transaction semantics, there are two types of transactions that differ in the way the application identifies which statements are to share the all‑or‑none property.
All three methods result in all the statements being backed out if any statement fails.
In this transaction type is... |
The application... |
Explicit (user‑generated) |
precedes the statements by a Teradata SQL BEGIN TRANSACTION statement and follows them with a Teradata SQL END TRANSACTION statement. |
Implicit |
submits the statements as a single request |