Re: How to tell if a given temporary table exists in the current session?

On Jan 29, 9:51 am, "John Hardin" <jhar...@epicor.com> wrote: > "Art Kagel" <art.ka...@gmail.com> wrote in message > > news:mailman.509.1264734584.6236.informix-list@iiug.org... > > > On Thu, Jan 28, 2010 at 8:44 PM, John Hardin <jhar...@epicor.com> wrote: > > >> I have a need to detect and drop temporary tables from SQL if they exist > >> in > >> my session. > > > The only way to do this in an SPL routine is to DROP the temp table at the > > beginning of the routine, but trap the -206 error that occurs when the > > table > > is not found and ignore it.  Then continue to create the temp table as if > > it > > had been dropped successfully.  Not elegant, but it's the only way that > > works. > > It doesn't work very well. How do you restore trapping of -206 exceptions so > that valid errors of that sort in the stored procedure are properly trapped? > > Ignoring exceptions generated for what arguably should not even _be_ an > error in the first place will also ignore valid exceptions that do indicate > serious problems in the process that need to be fixed. > > -- > John Hardin KA7OHZ > Senior Applications Developer, BI SpecialistEPICORRetail >   web:http://www.epicor.com > voice: (425) 245-1800 >   fax: (425) 670-1810 > email: <jhar...@epicor.com> > 20818 44th Ave. W., Suite 270 > Lynnwood, WA 98036 USA > Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA > ------------------------------------------------------------------------ >  The first time I saw a bagpipe, I thought the player was torturing an >  octopus. I was amazed they could scream so loudly. > ------------------------------------------------------------------------ > > --- news://freenews.netfront.net/ - complaints: n...@netfront.net --- sadadasasdsa