Re: Temp Table not being deleted

In article <3307E885.6BC6@sgen.com.au>, 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 > >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. > >Has anyone ever come across this situation or another situation >where a temp table is not being drop. > >Your help would be appreciated >Thank you > >Adam Sorati From my experiance, the table is still in effect until you you end the session / application which called the session. Or you explicitly drop the table. -Joseph