NOHOLDLOCK
|
Syntax: |
NOHOLDLOCK = <Name of Index File> | ALL <Name of Index File> = <INDEX
FILE> |
||
|
Meaning: |
The currently read record from an Index File
remains not locked. If NOHOLDLOCK is enabled for an Index File,
every read data record is in the multi-user operation only locked while it is
read and immediately unlocked after it has been read. If the record is rewritten or deleted later
on, the error 1065/927 is reported if the data record has been deleted in the
meantime. The error 1065/926 is reported if the data record has been changed
in the meantime. The
advantage of NOHOLDLOCK is that data records are only locked for a very short
time, which prevents deadlocks and impediments. All
users can therefore always ‚see’ all the data records. The disadvantage is that a
data record cannot be rewritten or deleted if it has been changed or deleted
in the meantime. NOHOLDLOCK does not have any effect if NOREADLOCK or NOUNLOCK has been activated for the respective index
file. With NOREADLOCK the data records are not locked anyway, with NOUNLOCK they must remain locked
until the command UNLOCK is given. NOHOLDLOCK ALL disables the Record-Locking for
all Index Files. NOHOLDLOCK is the default setting for all
Index Files at he start of the program. |
||
|
Parameter: |
|
||
|
Sample: |
NOHOLDLOCK CUSTOMER |
||
|
See also: |
|