Re: Temp Tables

From: anandpa@my-deja.com > > In our application, we have a need to store >a table data temporarily in a temporary table, and >regularly at night we need to update the actual table >from temporary table. Just be aware that a temp table will be dropped if the session dies. I therefore think that an actual temp table would be a *very* bad idea. I would therefore create a permanent clone of the employee table and purge it after you're finished processing. But this seems like a very curious requirement. Perhaps if we understood the underlying issue better we might find a better solution? >If the table name is employee, we need to take >some data from employee table in morning, put it >in temporary table, do processing on it( without disturbing >data in actual employee table), and then in night >finally update the actual employee table from the >temporary table. >How do i handle this in informix? >Do i have to( and how do i?) maintain two versions of employee >table? do i need to write some stored procedure >to handle this? Yes and maybe. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com