15.10 - Teradata Transaction Semantics - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Call-Level Interface Version 2
Programming Reference

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).