Teradata Transaction Semantics - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata Transaction Semantics

Two modes of transactions are available:

  • Teradata
  • ANSI
  • 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.

  • Explicit
  • Implicit
  • 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