>>-WITH--+-CS------------------+-------------------------------><
+-UR------------------+
+-RR--+-------------+-+
| '-lock-clause-' |
'-RS--+-------------+-'
'-lock-clause-'lock-clause
|--USE AND KEEP--+-EXCLUSIVE-+--LOCKS---------------------------|
+-UPDATE----+
'-SHARE-----'
CS - Cursor stability
UR - Uncommitted read
RR - Repeatable read
RR lock-clause
Repeatable read, using and keeping the type of lock that is specified in lock-clause on all accessed pages and rows
RS - Read stability
RS lock-clause
Read stability, using and keeping the type of lock that is specified in lock-clause on all accessed pages and rows
lock-clause
Specifies the type of lock.
USE AND KEEP EXCLUSIVE LOCKS
USE AND KEEP UPDATE LOCKS
USE AND KEEP SHARE LOCKS
Specifies that DB2® is to acquire and hold X, U, or S locks, respectively.
