Progress
Startup Command and Parameter
Reference


No Lock (-NL)

Operating 
System
and
Syntax 
UNIX
Windows 
-NL 
Use
With 
Maximum
Value 
Minimum
Value 
Single-user
Default 
Multi-user
Default 
CS, OID (Version 7.3B and later)
 
 
 
 

Use No Lock (-NL) to have all record retrieval statements default to NO-LOCK record access. In order to get the NO-LOCK default for any procedure, it must be compiled in a Progress session started with -NL. Running Progress with -NL has no affect on precompiled procedures.

When a transaction ends, EXCLUSIVE locks are downgraded to SHARE-LOCK, regardless of the -NL parameter.

For Version 7.3B and later, you can specify -NL as a startup parameter for the Open Interface Driver to support ODBC applications that perform multiple connections to the same data source, lock all records in a read table, or that otherwise exceed the lock table size with large databases.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095