Can someone please help find what is wrong with this code:

DECLARE GLOBAL TEMPORARY TABLE GLOB1(ID BIGINT) WITH REPLACE;
LOAD FROM "C:\loadtab.txt" OF DEL MESSAGES "C:\loadtabmsg.txt" INSERT INTO SESSION.GLOB1;

I get the following error on the LOAD statement even though the declare statement was successful:
SQL3304N The table does not exist.

If I replace the session.glob1 with name of some table from the db, it works fine. There is only one column of data in the txt file and the data types are fine.

Thanks for any help.

You can't use LOAD with temporary tables.

Thanks, JP.