Re: Handling temporary tables in Informix

The scope of a temporary table is limited to the life of the session, so do all your processing inside of a transaction to avoid all the hard work of building the temp table. begin work; create temp table tab1; insert into tab1 ..........; select blah from tab1 ;commit work; Hope it helps. -Abraham --- Suket <suketsinha@indiatimes.com> 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. > > Is there is any way to handle this. > > Currently using Informix 9.3 on HP-UX 11. > > Regards, > Suket __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com sending to informix-list