All-Or-Nothing Property - 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

Teradata SQL INSERT statements can be used to add rows of data to a table. They are similar to the write statements used to add records to a file. Teradata SQL SELECT statements can be used to read rows of data from a table. Occasionally, an application requires that a set of Teradata SQL statements must all be complete or all be backed out.

Example

If money is being transferred from one account to another, the UPDATE statement that subtracts the amount from the first account and the UPDATE statement that adds the amount to the second account must both take place or neither take place.