Multiple ROLLBACK Requests - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

If a macro or multistatement request contains multiple ROLLBACK requests, those requests are initiated in the order specified, even if the expressions could be evaluated immediately by the parser because the request does not access any tables. See Two Types of ROLLBACK Requests. However, the system can process ROLLBACK requests in parallel.

If the system processes the ROLLBACK requests in parallel, and one of the requests actually does roll back, then the system reports that rollback regardless of its specified sequence in the macro or multistatement request.

You can examine the EXPLAIN report for the macro or multistatement request to determine whether the system is executing the ROLLBACK requests in parallel or not.