Description

VALUES
Introduces a single row consisting of one of more columns.
expression
Specifies the new value of the variable. The expression is any expression of the type described in Expressions. It must not include a column name. Host structures are not supported.
NULL
Specifies that the new value for the variable is the null value.
row-fullselect
A fullselect that returns a single result row. The result column values are assigned to each corresponding variable. If the result of the fullselect is no rows, then null values are assigned. An error is returned if there is more than one row in the result.
INTO variable,...
Identifies one or more host structures or variables that must be declared in the program in accordance with the rules for declaring host structures and variables. In the operational form of INTO, a reference to a host structure is replaced by a reference to each of its variables. The first value specified is assigned to the first variable, the second value to the second variable, and so on.