Progress
Portability Guide
Record Locking
Progress supports two types of record locking-shared and exclusive. When working with DataServers, you must be aware that non-Progress database managers implement different record locking procedures. For example:
- The DataServer for C-ISAM does not support shared record locks; all record locks are exclusive.
- C-ISAM provides two types of record locking (automatic and manual) and two types of file locking (exclusive and manual).
- The DataServer for C-ISAM uses manual locking at the table and record levels. It does not support C-ISAM automatic record locking. The DataServer opens files with manual locks, allowing multiple programs to access the files.
Progress applications rely on the ORACLE RDBMS to handle all locking for the target ORACLE database. Progress locks do not apply to your ORACLE database.
The DB2/400 database supports NO-LOCK, SHARE-LOCK, and EXCLUSIVE-LOCK when you use the Progress Lock Table on the server. If non-Progress applications are running against the database, do not use the Progress Lock Table and limit your access to NO-LOCK and EXCLUSIVE-LOCK.
See the appropriate Progress DataServer Guide for a comparison of Progress locks to their non-Progress equivalents.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |