Products Downloads


French version


 

 

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

 

↑ Top of page


  • Aucune étiquette