>>-WITH--+-NC------------------+------------------------------->< +-UR------------------+ +-CS--+------------+--+ | '-KEEP LOCKS-' | +-RS--+-------------+-+ | '-lock-clause-' | '-RR--+-------------+-' '-lock-clause-' lock-clause: |--USE AND KEEP EXCLUSIVE LOCKS---------------------------------|
The isolation-clause specifies an isolation level at which the select statement is executed.
If isolation-clause is not specified, the default isolation is used with the exception of a default isolation level of uncommitted read. See Isolation level for a description of how the default is determined.
Exclusive locks: The USE AND KEEP EXCLUSIVE LOCKS clause should be used with caution. If it is specified, the exclusive row locks that are acquired on rows will prevent concurrent access to those rows by other users running COMMIT(*CS), COMMIT(*RS), and COMMIT(*RR) till the end of the unit of work. Concurrent access by users running COMMIT(*NC) or COMMIT(*UR) is not prevented.
Keyword Synonyms: The following keywords are synonyms supported for compatibility to prior releases. These keywords are non-standard and should not be used:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.