Row locks in DB2/400 UDB by Alexei Pytel

Found on the Midrange-L Mailing List: www.midrange.com


If you do 
        DECLARE CURSOR cursor1 FOR SELECT field1    .....   For UPDATE OF 
field1
        OPEN cursor1
        FETCH FROM cursor1 ... INTO var 
        var = var + 1
        UPDATE field1 = var .... WHERE CURRENT OF cursor1

the row will be locked between FETCH and UPDATE at any isolation level.

    Alexei Pytel
always speaking for myself

[report a broken link by clicking here]