<<

Contents

Search

>>

 

NOHOLDLOCK

 

 

Instruction

 

 

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:

Name of Index File

Name of Index File

 

Sample:

NOHOLDLOCK CUSTOMER

 

See also:

HOLDLOCK

READLOCK

NOREADLOCK

UNLOCK

NOUNLOCK