The figure shows positioned updates and deletes
without optimistic concurrency control. The following table shows
what happens in the application and in Db2® at three points.
| Time | Event in application | Response in Db2 |
|---|---|---|
| 1 | FETCH row 1 | Lock row 1 |
| 2 | FETCH row 2 | Unlock row 1, lock row 2 |
| 3 | UPDATE WHERE CURRENT OF | Update row 2 |