Re: ? SET ISOLATION

Posted in 1995

W Mat Waites — Thu, 9 Mar 1995 02:58:33 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3jiggo$o69@cssun.mathcs.emory.edu> xrizzi@arcride.edu.ar writes: [ some stuff deleted ] > > The locks level of the table used in the CURSOR is to ROW. > > From different processes is NOT possible to agree to rows NOT selected >by the CURSOR FOR UPDATE. > > The messages error of informix is the following: > > - 246 could not I give an indexed read to get next row. > > Please, us interesting to know if the explained procedure is incomplete >or exists some another alternative that we have not considered. It sounds like you are hitting the "adjacent row key locking" problem. This is supposedly fixed in 6.0. When a row is locked, the row before it and after it is also locked. Kooky, eh. You must either spend alot of time working out a way to get around this problem, or go for 6.0/7.1. Good Luck, Mat -- W Mat Waites | mat@rencorp.com REN Corporation - USA | (615) 353-4110