====== VALUES INTO Statement - PL/HQL Reference ======

You can use the VALUES INTO statement to assign values to variables in PL/HQL. 

If the variable was not explicitly declared before the assignment, a new variable is created and its data type is derived from the assignment expression.

**Syntax:**

<code language=sql>
VALUES expression INTO var;
|
VALUES (expression [, expression2, ...]) INTO (var [, var2, ...]); 
</code>

Example:

<code>
VALUES 'A' INTO code;
VALUES (0, 100) INTO (count, limit); 
</code>

**Compatibility:** IBM DB2

**Version**: PL/HQL 0.03

See also:
  * [[assign|SET Statement]]