Teradata Transaction Semantics
When working with Teradata Database for UNIX release 2 (or later), two modes of transactions
are available:
Teradata
ANSI
If Teradata transaction semantics are used, three types of transactions differ in
the way an application identifies which statements share the all‑or‑none property.
All three methods back out all statements if any statement fails:
Explicit (user-generated)- Precedes the statements by a BEGIN TRANSACTION statement
and follows them with an END TRANSACTION statement.
Implicit - Submits the statements as a single request.
2PC (two-phase commit) - The action depends on CICS or IMS sync point services to
commit or roll back transactions. The use of the sync point services guarantees that
all updates performed within a logical unit of work will either all commit or all
roll back. 2PC requires Teradata Database for UNIX version 2 release 2 (or later),
or Teradata DBS for TOS version 1 release 5 (or later).