Re: Handling temporary tables in Informix

Don't connect to the other database. If you need information on the other database use sintax: a) <database>:<table_name> -- iif on same server b) <database>@<server>:<table_name> -- iif on another server If you need to do it as you describe, unload the temp table to file (unload) connect to the other database, create the temporary table and load the file you previously created... Don't suggest doing so. Chucho! 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. > > Is there is any way to handle this. > > Currently using Informix 9.3 on HP-UX 11. > > Regards, > Suket > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list