SET | Teradata Vantage - SET - Advanced SQL Engine - Teradata Database

Assigns a value to a local variable or parameter in a stored procedure.

ANSI Compliance

SET is ANSI/ISO SQL:2011-compliant.

Required Privileges

None.

Invocation

Executable.

Stored procedures only.

Syntax

SET assignment_target = assignment_source ;

Syntax Elements

assignment_target

The name of the variable or parameter to be assigned a value.

assignment_source

The value to be assigned to assignment_source.

Usage Notes

• All valid expressions except those containing subqueries are permitted in a SET statement assignment source.
• Both assignment target and assignment source must be specified.
• Assignment target is always on the left hand side (LHS) of the SET expression.
• Assignment source is always on the right hand side (RHS) of the SET expression.
• The data type of the assignment source must be compatible with the data type specified for the assignment target. Vantage performs implicit conversions for DateTime data types when the source data type differs from the target data type. For more information, see Teradata Vantage™ - Data Types and Literals, B035-1143.

Example: Using the SET Statement to Assign Values

The following example illustrates a valid use of the SET statement to assign values to variables and parameters.

SET hNoAccts = hNoAccts + 1;
SET hErrorText = 'SQLSTATE: '||sqlstate|| 
', SQLCODE: '||sqlcode||', ACTIVITY_COUNT: '
 ||activity_count;