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 Information
| For more information on… | See… |
|---|---|
| Locks and concurrency control | SQL Request and Transaction Processing, B035-1142. |
| Session isolation level | SQL Request and Transaction Processing, B035-1142. |