Does anyone know of a way to check if a declared temporary table exists in DB2 v8?

We have a table declared like so...
DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_MSG(... [columns] ..)
WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED ON ROLLBACK PRESERVE ROWS;

Since declared temp tables aren't in the catalog, I'm not sure how to do it.

I want to create the table only if it doesn't exist (but keep the existing one if it's already there).

All I can think of is to try to query the table like "select count(*) from session.temp_msg". If you do not get an error then it is already defined.

HTH

Andy

Or just create it, and ignore any error message about "table already exists".

If you do not want to replace, why are you declaring WITH REPLACE ????

Exclude the clause and follow Peter Vanroose's suggestion

Sathyaram