17.10 - 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
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

The application can enforce the all-or-nothing property described above, but it is much simpler to have the database enforce it. The system enforces 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.