SET Clause - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

SET Clause

 

Syntax element …

Specifies …

column_name = expression

the value expression to be updated in column column_name. This can be a DEFAULT function.

Host variables in the SET clause must always be preceded by a COLON character.

You cannot specify a derived period column name.

mutator_method_name

the name of a mutator method that is to perform some update operation on column_name. See “Updating Structured UDTs Using a Mutator SET Clause” on page 481.