LOCK IN ROW
Posted in 1997
Hi Folks, I have a problem, when updating a row in my database (defined with buffered logging) as part of a transaction, another user than try to make a select statement in the refered table can't do it. The problem is a lock placed in rows other than the one updated. The table used is defined with granularity level to row. I did the test using all the isolation levels (repeatable read, cursor stability ,dirty read, committed read). I just could make the select when the dirty read isolation level was set. I am using Informix DSA 7.22 The question: Why i can't make a select to rows not updated during the transaction of another user? There is other ways to make isolation ?? There is an enviromment variable that i should set??? Any comments, ideas or help will be appreciatted. Thanks in advance, Javier Puente Computer Engineer Noboa Coporation