I have Informix Server 7.3 installed on Win NT and I want to delete records from a table but it keeps saying the recorda are locked (107:ISAM record, record is locked and 244: could not do a physical order read to fetch next row).All other users are not logged in. How do I unlock the tables or initialize the database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
records locked in table?
- Thread starter alancasey
- Start date
This usually happens when another user is working in the table you are trying to update/delete. There are several solutions to this. If possible, have everyone logout of the table while you update.
Otherwise try this:
You can obtain exclusive access to a table by
passing the ISEXCLLOCK flag to isopen.
The simplest way to handle this error is to use the statement SET LOCK MODE TO WAIT. For bulk updates, see the LOCK TABLE statement and the EXCLUSIVE clause of the DATABASE statement. Dodge20
If it ain't broke, don't fix it.
Otherwise try this:
You can obtain exclusive access to a table by
passing the ISEXCLLOCK flag to isopen.
The simplest way to handle this error is to use the statement SET LOCK MODE TO WAIT. For bulk updates, see the LOCK TABLE statement and the EXCLUSIVE clause of the DATABASE statement. Dodge20
If it ain't broke, don't fix it.
- Status
Similar threads
- Locked
- Question
- Locked
- Question