Since global temporary tables are not stored in syscat.tables, is it possible to check if a global temporary table exists via a SQL statement?

I want my code to create the global temorary table only if it doesn't already exist.

Thanks,
Mark

You can create the GTT and then check for SQLSTATE value ... If your SQLSTATE value is 0 or that of 'Object already exists' continue to your next step

Cheers
Sathyaram

I am not sure if this will work for you, but you could use the "WITH REPLACE" option on the DECLARE GTT statement. This will create the table if it does not exist. But if the table does exists, it will effectively drop the existing definition and replace it with the new, including all the data in the existing GTT.

Andy