Does DB2 know how to avoid locking a row when we do a qualified update
E.g. Table X has three columns A, B, C
and has a row with values 1,2,3 respectvely
and A is the primary key
Now if I do an UPDATE
E.g.
UPDATE X
set A=1,B=2,C=3
WHERE A=1 AND B<>2 and C<>3
Does this invoke locking the row while the WHERE clause of the UPDATE is being verified.
RB
E.g. Table X has three columns A, B, C
and has a row with values 1,2,3 respectvely
and A is the primary key
Now if I do an UPDATE
E.g.
UPDATE X
set A=1,B=2,C=3
WHERE A=1 AND B<>2 and C<>3
Does this invoke locking the row while the WHERE clause of the UPDATE is being verified.
RB