values-into
Differences
This shows you the differences between two versions of the page.
|
values-into [2015/09/23 20:27] |
values-into [2015/09/23 20:27] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== 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]] | ||
Page Tools
