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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.