Global Temporary Table

CREATE GLOBAL TEMPORARY TABLE global_temp_table1
 ON COMMIT PRESERVE ROWS
 AS
--------------------------------------------------
Select field,
;
TRUNCATE TABLE GLOBAL_TEMP_Table1;
  DROP TABLE GLOBAL_TEMP_Table1;