I am getting complilation error when trying to drop GLOBAL TEMP TABLE.
I used ON COMMIT DROP option while declaring GLOBAL TEMPORARY TABLE.
I got following error message: DSNHPARS LINE 609 COL 17 INVALID KEYWORD "ON";
I reffered application programming and SQL guide version 9.1 to have a look at the syntax.
On page 447, I observed that there are only 2 options available for GLOBAL TEMPORARY TABLES.
ON COMMIT DELETE ROWS and ON COMMIT PRESERVE ROWS.
So is ON COMMIT DROP option not available with GLOBAL TEMPORARY TABLES?
If it is available what is syntax?
If it is not available, how am I supposed to drop this table? Can I drop it once data is returned to front end by using cursor on this temp table?
Your help is highly appriciated!!