Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Martin, Wayne E. — — source: Informix-list mailing list archive (1991-1998)
How about:
set isolation to dirty read;select record_from_table ... ;
set isolation to committed read;delete from table where rec-id_key = record_from_table;
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Danny De Koster [mailto:ddk@fidelity-soft.be]
Sent: Tuesday, January 09, 2001 12:11 PM
To: informix-list@iiug.org
Subject: problem with lock of a record
Hi experts,
When I want to use a table in which somebody has locked 1 row, the system
answers that the record is locked.
It seems to me incredible that there is no possibility to delete a record in
a table when somebody else locks another record in that table.
The system answers: 244: Could not do a physical-order read to fetch next
row.
107: ISAM error: record is locked
I have already done: alter table w_verklo lock mode (row)
and: set lock mode to wait 5
I'm using INFORMIX OWS 7.31.UC6
Thanks for any solution.
Danny
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.