Statements and Transactions - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
uny1527114222311.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

The application can enforce the all-or-nothing property described above, but it is much simpler to have the Teradata Database enforce it. The system will enforce the all-or-nothing property if it has the information that one or more statements constitutes a transaction. If one of the statements in a transaction fails, the system aborts the transaction and returns any database that was affected to the state it would have been in if the transaction had not been submitted.