Temporary Tables

DECLARE GLOBAL TEMPORARY TABLE SESSION.ESM_EXTRAS
(
ESMP CHARACTER(30)
)
ON COMMIT PRESERVE ROWS;