Handling temporary tables in Informix

Hi, My Informix 4gl program has functions, which: 1) Creates a temp table, loads data into it 2) Access the temporary table Now in 2) , there is a line which resets connection to database by : DATABASE <database name> Note that this database name is same as used in 1) Now the program gives SQL error 206 for table not found at runtime. My query is whether this behaviour ( automatically dropping temporary tables, when database connection is reset) is consistent for Informix versions 7.2/7.31/9/3. Is there is any way to handle this. Currently using Informix 9.3 on HP-UX 11. Regards, Suket

On 3 Sep 2003 20:34:15 -0700, suketsinha@indiatimes.com (Suket) wrote: >Hi, > >My Informix 4gl program has functions, which: >1) Creates a temp table, loads data into it >2) Access the temporary table > >Now in 2) , there is a line which resets connection to database by : >DATABASE <database name> >Note that this database name is same as used in 1) > >Now the program gives SQL error 206 for table not found at runtime. > >My query is whether this behaviour ( automatically dropping temporary >tables, when database connection is reset) is consistent for Informix >versions 7.2/7.31/9/3. > Yes, that is why they are called "temporary". >Is there is any way to handle this. Make "permanent" table or don't "reconnect" to database. Why are you doing it, anyway? Nebojsa ------------------------------------ Remove spam block (DELETE_) to reply