I need to create a Global Temporary Tabe in DB2 (this is comparable to a Focus hold file).
The syntax for this begins DECLARE GLOBAL TEMPORARY TABLE...

Apparently, the for DB2 adapater DELCARE is a reserved word. Consequently, the adapter hiccups and nothing but an error message occurs.

I need a DB2 table that will disappear when I am finished with it. I need a DB2 table that will not raise the ire or incur the wrath of the DBA.

Any ideas?

Maybe a DB2 Stored Procedure?

If you write permission to DB2 then you can
try in the Table..
ON TABLE HOLD AS name FORMAT DB2