Purpose
Determines whether SELECT requests embedded in INSERT...SELECT, UPDATE...SELECT, and DELETE...SELECT requests place READ or ACCESS locks on the source table.
Field Group
General
Valid Settings
| Setting | Default Locking for Outer SELECT and Ordinary SELECT Subqueries | Default Locking for SELECT Embedded In DELETE, INSERT, MERGE, or UPDATE Request |
|---|---|---|
| TRUE | READ | ACCESS |
| FALSE | READ | READ |
Default
FALSE
Changes Take Effect
After the DBS Control Record has been written.
Related Topics
| For more information on… | See… |
|---|---|
| Locks and concurrency control | SQL Request and Transaction Processing. |
| Session isolation level | SQL Request and Transaction Processing. |