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...
3. Host-Variable is a host variable.
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.