No Lock (-NL)
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Use No Lock (-NL) to have all record
retrieval statements default to NO-LOCK record access.
| Operating system and syntax | UNIX / Windows |
-NL
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Session | — | — | — | — |
If a session is started with -NL, then
NO-LOCK is applied to record retrieval statements (such as
FOR, FIND, and static queries opened with OPEN
QUERY) during the compilation of any source code containing those statements.
For dynamic built-in methods that retrieve records, -NL must be specified
at runtime since the compilation of such record retrieval is done when the methods
execute.
When a transaction ends, EXCLUSIVE locks
are downgraded to SHARE-LOCK, regardless of the -NL parameter.