ANSI 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
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities
If you are using ANSI transaction semantics, the first request begins a transaction implicitly. All subsequent requests are part of the transaction until one of the following events occurs:
  • SQL COMMIT statement
  • SQL ROLLBACK statement
  • LOGOFF statement
  • Failure response

A failure response rolls back only the statement causing the error unless that error threatens the integrity of the database, in which case the entire transaction is rolled back.