create procedure run_stmt(stmt varchar( 4000 ))
begin
  declare SQLCODE,rs int DEFAULT  0 ;
  declare continue handler for sqlexception
    set rs = SQLCODE;
  execute immediate stmt;
  return rs;
end@

create function run_stmt(stmt varchar( 4000 ))
returns table (rs int)
modifies sql data
begin atomic
  declare r int;
  call run_stmt(stmt);
  get diagnostics r = DB2_RETURN_STATUS;
  return values r;
end@

select * 
from table(run_stmt('declare global temporary table session.a (i int) with replace on commit preserve rows')) t@

select * 
from table(run_stmt('insert into session.a values 1')) t@

select * from session.a@