
The concurrent-access-resolution-clause specifies the concurrent access resolution to use for the statement.
>>-+-SKIP LOCKED DATA--------+--------------------------------->< +-USE CURRENTLY COMMITTED-+ '-WAIT FOR OUTCOME--------'
Specifies that the select-statement, searched
UPDATE statement (including a searched update operation in a MERGE
statement), or searched DELETE statement that is prepared in the PREPARE
statement will skip rows when incompatible locks are held on the row
by other transactions. These rows can belong to any accessed table
that is specified in the statement. SKIP LOCKED DATA can be used only
when isolation level NC, UR, CS, or RS is in effect.
SKIP LOCKED DATA is ignored if it is specified when
the isolation level that is in effect is RR.
