ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) (S) |
(B) (S) |
(I/B) (S) |
(I) (S) |
Section for use
All
Syntax
UNLOCK ViewName
Description
Whenever update instructions are used on files ( UPDATE, DELETE, DELETE_ON_KEY, CREATE, STORE, CLASSIFY, SUPPRESSION_L1, SUPPRESSION_L2), every record reading locks the record, until another read or update operation is performed on these files.
The UNLOCK instruction will unlock a record which has just been read, without performing an update on the data file.
Important note: If only read operations are performed on a file, do not use the UNLOCK instruction: this will declare the file to be in an "update" mode (instead it must be declared in an "input" mode), and therefore every read operation will lock the records.
Example
**********************
INITIALIZATION 01
**********************
* This transaction is used for both DISPLAY and UPDATE modes
CHAIN CUSTOMERS
IF CUSTOMERS EXISTS AND *LOCKED = '0' AND MODE = 'DISPLAY'
* unlocks it only if mode is DISPLAY
UNLOCK CUSTOMERS
END