Progress
Startup Command and Parameter
Reference
No Lock (-NL)
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 |