I am developing SQL stored procedure. I need to declare global temporary table in dynamic SQL programs. How can I do it? e.g.
declare global temporary table lookup
as (--use dynamic SQL statement--) definition only
with replace
not logged
in --dynamic definition of the user temporary table space--

I very need for this function. Please help me to do it. I'll expect your answer.