Re: Check for existance of a temp table

Posted in 2003

Jonathan Leffler — Thu, 13 Nov 2003 05:27:40 GMT — source: Usenet: comp.databases.informix

don hunt wrote: > Is there a way to check for the existance of a temp table? Try creating a new one with the same name. If it works, the table wasn't there (but is now - you should drop it). If it doesn't work, then the table already existed. This works independently of server versions - the alternative sysmaster solution won't work in OnLine 5.x or SE. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/