Teradata Transaction Semantics - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities
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.

If 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