Re: Selecting Locked rows

In article <33085AD0.2BC9@romac.com>, Timothy Jones <tojones@romac.com> writes >Engine 7.14UC1 > >When you run a select on a particular table, where can you look to see >if those rows that are being returned, have a lock on them? > >Thanks in advance. >Tim Jones Unless you are using an isolation level of dirty read you will not be able to read rows which are locked for update (you will get an error). With dirty read isolation level you do not know the lock exists, hence you can read locked rows (and possibly get inconsistent results). I would either a) go on an Informix training course or b) read the manuals. -- David Williams