SET variable

The SET variable statement produces a result table consisting of at most one row and assigns the values in that row to variables.

For more information, see SET variable in the SQL Reference topic in the Information CenterLink to Information center.