Re: Dropping Temp Tables (OnLine)

Posted in 1995

Mariusz D — 4 Dec 1995 16:54:14 GMT — source: Informix-list mailing list archive (1991-1998)

I had problems with dropping temp tables in all the engines, now I simply create the temp table once and then delete records from it as needed, so it can be reused again. Mariusz Malogrosz mariuszm@tecsys.com Kerry Sainsbury (kerry@kcbbs.gen.nz) wrote: : In article <30ba9e00.12959443@news3.cts.com>, : dwolt@cts.com (Dave Woltkamp) wrote: : >There have been a few messages posted here regarding the dropping of : >temp tables. We have many programs that drop temp tables and are : >currently using SE v5.1. We are about to convert to OnLine 7.1 and : >I'm wondering if dropping temp tables will cause us any headaches? : It causes us headaches in 6.x SE. We often get 'Table already exists' : errors if we try to re-create the TEMP table after the drop. : ------------------------------------,------------------------------------------ : Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 : Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] : New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " : Home: +64 9 279-3571 | http://www.garpac.com/informix.html