VALUES INTO
The VALUES INTO statement assigns one or more values to host variables.
VALUES { Expression, ... } INTO Host-Variable, ... { NULL, ... } |
Syntax rules
1. This statement is currently supported only on the IBM DB2 database and requires the
-csdb2 compiler option.
2. Expression specifies a value and can take a number of different forms. It can be a constant value, a special register, an arithmetic calculation, a function, etcetera...
4. NULL can only be specified for host variables that have an associated indicator variable.
General rules
1. The value of each Expression is stored in the corresponding host Host-Variable.
Examples
Assign the value of the CURRENT PATH special register to host variable HV1.
exec sql values(current path) into :hv1 end-exec. |