Re: Temp Table not being deleted

Adam Sorati <adams@sgen.com.au> wrote: :Has anyone ever come across this situation or another situation :where a temp table is not being drop. : :NEW SYSTEM OLD SYSTEM :O/S HP-UX 10 :Engine SE 7.1 SE 4.x :ISQL 6.0 4.x :4GL 6.0 4.x : 4GL 6.03.? or newer hopefully (i don't remember exactly what is the newest version, but early 6.0 versions had bugs). :After upgrading Informix, this 4GL report program is not working. : :The report creates a couple of temp tables and runs find the first time. :The second time the report runs it gives a 310 error tablename already :exsits. the tablename is the last temp table created. :When the user ends the application and runs it again, it runs fine. What kind of temp tables are you talking about? select ... into temp .., create temp table... or temporary tables the report are creating to do sorting? If you create them, do you also drop them? If not you will of course see the behaviour you are talking about. :Has anyone ever come across this situation or another situation :where a temp table is not being drop. There have been problems with temp tables not beeing droped as they should, but I believed that not to be a problem any more in SE 7.1 :Your help would be appreciated :Thank you : :Adam Sorati Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org