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
Is there is any way to handle this.
Currently using Informix 9.3 on HP-UX ...