Delete Lock
A lock is a Data Server repository security feature preventing a data intersection from being changed by another user or process until an operation is completed and the data intersection is released.
Use this command to release a lock on data in the Data Server repository. Users with Locks authorization can delete any lock in the system, while users without Locks authorization can delete their own locks only.
If you use this command in conjunction with the UseInputRelatedSchedules command, the original DataArea lock is deleted along with the locks for the related DataAreas for line item details, comments, and attachments.
For information on how this command is affected by input-related schedules, see UseInputRelatedSchedules.
Syntax:
DELETE LOCK ALL|USER USING dataspec.lvdsp [method ]["comment"]
where:
- ALL deletes all locks within the DataSpec that meet the conditions specified by the method.
- USER deletes all locks owned by the current user that meet the conditions specified by the method.
- dataspec.lvdsp is the name (and extension) of the DataSpec file.
- method can be one of the following:
Value Description MATCH
Deletes only locks that match the area defined by the DataSpec exactly. If you do not specify a method, MATCH is used by default.
ALL
Deletes any locks that are contained by the area defined by the DataSpec. Any lock that is only partially contained by the area defined in the DataSpec is not deleted.
- comment specifies the comment to match when deleting the lock.
Syntax example:
DELETE LOCK USER USING CopyNI.lvdsp MATCH "Delete Net Income Locks"
See also