ANSI Transaction-semantics - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities
ANSI Transaction-semantics are supported for Teradata Database for UNIX version 2 release 2 (or later). If ANSI Transaction-semantics are used, 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 Teradata Database, in which case the entire transaction is rolled back.