I don't think that will work, because the WRITEV is still inside the transaction. As a matter of fact, I think it will error out if there is no explicit readu preceding it. That might be isolation-level-dependent, but I don't think so.
> LOCK 50 > READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . > ...test for existence and get the next unique value ...update > record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 > UNLOCK 50 > > everyone gets the momentary lock they need and > transaction bracketing doesn't break the locking mechanism. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
