HELP: Lock rows in Informix SE

Hi there! We are running Informix SE V 5.0 with C-ISAM files on a UNIX Siemens RM400 machine. We have the following problem if we try to update records with the following command UPDATE tablename SET field = value WHERE condition The above only works if the affected table is not already open. If the table is open we get the following error messages: - 263: could not lock row for UPDATE - 107: C-ISAM error: row locked The same happens if we try to insert records except that instead of error message 263, we get the error message 271 ("new record can not be inserted into table"). Any help would be greatly appreciated. Please also email a copy of your reply as we are not regularly checking newsgroups. Thanks a lot Florian -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet