Re: Strange Problem in Informix

> =====> But program 2 has lock mode wait. so if some record is locked, > it should be waiting to read it whenever it becomes available. am i > right in assumming that ? No, because the record hasn't been committed yet so it's not "locked" in the conventional sense. If you want the mid-transaction record, I believe you'll need a dirty read isolation level. The problem there is if the transaction is rolled back, then you've just selected a nonexistent record.