This example shows how to use dynamic SQL (PREPARE and EXECUTE) to implement a VALUES INTO statement.

dynamic VALUES INTO

create procedure qgpl.values_into (out pout integer)
begin
  declare values_into_stmt varchar(1000) ccsid 37;
  set values_into_stmt = 'values 1+2+3 into ?';
  prepare values_into_query from values_into_stmt;
  execute values_into_query using pout;
end;

call qgpl.values_into(?);
-- Note that 6 is returned...

this is only necessary on prepare and execute? Because parameter markers cannot be used like so:

set  ? = 1 + 2 + 3 ;

or

select    1 + 2 + 3
into       ?
from      sysibm/sysdummy1  

Is there a reason why parameter markers cannot be used with the SET or SELECT INTO statements?