Re: Undocummented: SET ISOLATION TO DIRTY READ

Posted in 1994

"Paul Hatcher" — Wed, 11 May 1994 16:05:18 GMT — source: Informix-list mailing list archive (1991-1998)

I've found this problem on SCO at least to v4.10 - haven't tried 5.0 yet. Made it very nasty to use a scroll cursor as you couldn't even step past a locked record! The solution was to put a DIRTY READ/REPEATABLE READ pair around the scrolling portion. Paul Hatcher Graduate Associates Ltd +44 81 840 3110 - Phone phatcher@cix.compulink.co.uk +44 81 567 1894 - Fax