ROLLBACK Examples | SQL Statements | VantageCloud Lake - ROLLBACK Examples - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Example: ROLLBACK with a UDT in the WHERE Clause

The following examples show correct use of UDT expressions in the WHERE clause of a ROLLBACK request:

ROLLBACK WHERE (tab1.euro_col < CAST(0.0 AS euro));

ROLLBACK WHERE (tab1.cir_col.area() < 10.0);

Example: Using an SQL UDF in the WHERE Clause of a ROLLBACK Request

The following ROLLBACK request specifies an SQL UDF in its WHERE clause search condition.

     ROLLBACK FROM t1
     WHERE a1 = test.value_expression(2,3);