UPDATE Syntax Elements (ANSI Valid-Time Table Form) - Analytics Database - Teradata Vantage

ANSI Temporal Table Support
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantage™
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.