I have the following in a Stored Procedure

------------------------------------------------------------------------
DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_TABLE LIKE DB2RNT.EXISTING_TABLE WITH REPLACE;
ALTER TABLE SESSION.TEMP_TABLE ADD COLUMN COLUMN1 CHARACTER(7)
------------------------------------------------------------------------

It's generating a compile error
"[IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "ALTER TABLE SESSION..........................."

Can anyone help me fix this problem

TIA
- XLDb