16.20 - SET - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

A keyword introducing the SET statement used for assigning a value to a variable or parameter.

You can assign a UDT expression to a UDT variable or parameter; however, the mutator SET clause syntax (see UPDATE in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 for details about mutator SET clause syntax) is not supported within a SET statement. The workaround for this is to use the standard non-mutator SET clause format, with the column reference on one side of the equal sign and a UDT expression containing the appropriate mutators on the other side.

See Teradata Vantage™ SQL Stored Procedures and Embedded SQL , B035-1148 for details.