Statements and Transactions| - Statements and Transactions - 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

The application can enforce the all-or-nothing property, 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.