assignment_statement - Teradata Vantage

The SET statement.

See SET for details.

You can specify these options for assignment statements.

SET

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

assignment_target

Name of the variable or parameter to be assigned a value.

The parameter cannot be an IN parameter.

The variable cannot be named QUERY_BAND.

You cannot set values for status variables in SQL procedures.

assignment_source

Arithmetic and string expressions that contain the value to be assigned to a variable.

SQL procedure local variables, status variables, IN or INOUT parameters, and FOR loop column and correlation names can be specified in the assignment_source, which is also known as a value expression.