Re: How to drop a temp table using "if exists" logic ?

Thanks Bozon for articulating so clearly the need for the existence of temp tables. Somehow I feel that it is always much cleaner to check for existence and drop it if exists EXPLICITY, rather than firing the 'drop table' command and ignoring the warning. I could not find a solution though :) - Murty

Veeru71 wrote: > Thanks Bozon for articulating so clearly the need for the existence of > temp tables. > Somehow I feel that it is always much cleaner to check for existence > and drop it if exists > EXPLICITY, rather than firing the 'drop table' command and ignoring > the warning. > I could not find a solution though :) > - Murty > Do you also test for existence of a data row before you attempt to update it? Makes for a good buffer pool hit ratio if nothing else... I actually presented on that very topic at WAIUG last week. FWIW, in a language that has condition handlers the code to drop a table is a lot cleaner that that spattered with error-tests. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab WAIUG Conference http://www.iiug.org/waiug/present/Forum2006/Forum2006.html