17.10 - UPDATE Syntax Elements (ANSI Valid-Time Table Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)
valid_time_table
The valid time table in which you are modifying rows.
FOR PORTION OF
Qualifies rows to be modified that have valid-time periods that are within or that overlap the period defined by point_in_time_1 and point_in_time_2.
valid_time_period_name
The name of the valid-time derived period column. This is not “VALIDTIME.” It is the name assigned to the derived period column when the table was defined.
point_in_time_1
point_in_time_2
Delimits the period of applicability of the modification.
A date or timestamp expression that can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a DATE or TIMESTAMP[(n)] [WITH TIME ZONE] value.
The expression can be any expression, including parameterized values and built-in functions such as CURRENT_DATE, CURRENT_TIMESTAMP, TEMPORAL_DATE, or TEMPORAL TIMESTAMP. The expression cannot reference any columns, but it can be a self-contained noncorrelated scalar subquery.
SET set_clause_list
WHERE search_condition
For information on the this syntax and other nontemporal keywords, clauses, and options for UPDATE, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.
The SET clause cannot include the start or end column components of the valid time period.