Re: ISAM error: the file is locked???

Temporary tables are unique to the process creating them; they cannot be seen by any other process at any time. The use of the owner name is redundant. You've probably found a bug, which should probably be reported to Informix Tech Support, but the workaround is obvious and safe for all versions of Informix -- do not use the owner name on temporary tables. Note that even if the same user is running the same program on two different terminals concurrently (or even the same terminal), the temp tables in the first process are completely disjoint from the temp tables of the second process. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: The only privilege problem seems to be universal access to an English dictionary. The number of times this word is misspelled is apalling! }From: keiths@prestongates.com }Subject: ISAM error: the file is locked??? }Date: 26 Jun 1996 16:47:15 GMT }X-Informix-List-Id: <news.25453> } }I get an SQL error -242 "could not open database table (username.tempapply) }System error number -113 }ISAM error: the file is locked } }This seems to happen only on temporary tables that are created with the }user name as a prefix. This is supposed to make it unique so that when }someone else is running another program that creates the same temporary }table with a different user name as a prefix. } }This was not a problem in 5.01 but seems to be in 7.12. }Is there a priviledge problem? } }Help! }Keith } }Please send responses to keiths@prestongates.com