Re: Making TEMP TABLES sticky

In <4mtt13$4jb@cssun.mathcs.emory.edu> elderbox@teleport.com writes: > >I have an associate who swears there is a way to make temp tables remain >after a process has completed. He thinks this has to withe the WITH NO >LOG keywords. I don't why he cares. It seems to me that if you want a >table to remain you just create a file, but he cares. We have reviewed >several Informix manuals and cannot find a reference to the temp tables >remaining after process completion. > >Just to satisfy him, I have agreed to ask this august group. Does >anyone know of a scenario where a temp table remains after a process >completes? Thank you > > > > > If this answer satisfies your associate, he needs to adjust his or her priorities. When an application creates an explicit temporary table via: SELECT * FROM CUSTOMER INTO TEMP TEMP_TABLE. The table will exists until the application takes one of the following actions. 1. The application terminates. 2. The application closes the database in which the table was created and the application opens a database in a different database server. 3. The application closes the database in which the table was created. In this case, the table is dropped only if the database does transaction logging and the temporary table was not created with the NO LOG option. NOTE: This answer is directly from the Informix Administrator's guide. Wes Loftis