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

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 The temp table will be dropped when you close the database connection. You can also explicitly drop a temp table if you wish. Has your 'session' terminated? Or has your SP terminated? Two different things. Close the database connection, and open it again. Is the table still there? Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+