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

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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