Re: Temp Table not clear after the informix session has terminated

Posted in 1998

V.Salvador — Sun, 22 Nov 1998 20:06:52 +0100 — source: Informix-list mailing list archive (1991-1998)

It seems to me, there is a bug. I noticed that bug to informix but I not remember at wich version. Considere to upgrade your IDS to 7.24 V.Salvador DEISTER, S.A. (SPAIN) jh wrote: > Hi, > > I've a store procedure that will be called by an application. The store > procedure when invoked will create temp table 'with no log' option. After > the procedure has run by the application, I make a select on the systabnames > and found that the temp table is present there. My question is how can I > clear the 'temp' table when a normal drop table command is unable to perform > the task. In the first place, why is the temp table not cleared after the > session has been terminated ?? > > I'm using ODS 7.22.uc2 and Solaris 2.5.1 > > Thanks > > JH