Using Temp Table got -314

Hello, My environment: HP_UX 10.01 U, C4gl 4.10.UD2 ONLINE 5.00.UC3(buffered log) Recently I have a program to create temp table with no log and declare a cursor to use it. But the program stops at FOREACH statement(see attach). My question is the temp table tbl_ls is used by creater only and who lese can use it ( from message: Table currently in use)? Or something else? Please e-mail me jshu@phjw.com . Thanks a lot. John Shu ------------------- JS1 follows -------------------- Date: 10/03/1996 Time: 15:57:49 Program error at "d_coll.4gl", line number 2166. SQL statement error number -314. Table (user.tbl_ls) currently in use. SYSTEM error number -106. ISAM error: non-exclusive access. Date: 10/04/1996 Time: 08:53:16Program error at "d_coll.4gl", line number 2163. SQL statement error number -242. Could not open database table (user.tbl_ls). SYSTEM error number -135. ISAM error: tblspace does not exist Where: -314 Table table-name currently in use. This statement tries to do something, for example drop a table, that cannot be done while the table is in use by another user. Wait a short time and try again. To make sure that no table is in use, open the database with DATABASE EXCLUSIVE. -135 ISAM error: tblspace does not exist. This error may indicate corruption of control information in the root dbspace, a serious problem that may require restoring the system from archive. In the short term, the current transaction should be rolled back and the application terminated. Then the OnLine administrator should run the tbcheck utility. -106 ISAM error: non-exclusive access. The ISAM processor has been asked to add or drop an index when it does not have exclusive access. C-ISAM programs: Before doing this operation the file must be opened with exclusive access. Review the program logic and make sure it opens this file passing the ISEXCLLOCK flag to isopen. SQL products: Should not occur; please note all circumstances and contact the Informix Technical Support Department.