Problem:

Customer defined an TEMPORARY TABLE:

DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_EMP

   (EMPNO   CHAR(6)        NOT NULL)

    ;

---> Execution Successful

Then he tried to insert some values into this table:

INSERT INTO SESSION.TEMP_EMP

VALUES ('TESTNO');

---> This failed with "X028: Cannot find table/view/synonym "SESSION.TEMP_EMP"

Resolution:

Use of temporary tables is only supported in DB2 version V7/8 and later.

Please ensure you are using an XDB  location of this version.