System Lock File Requirements

System Lock File Requirements

Lock files are used in Elliott to prevent users from entering transactions when other users are posting, to prevent users from entering transactions when invoices are printed, or to prevent multiple people from printing purchase orders at the same time. For the lock file to work, it must meet the following conditions:

It should be an indexed file with the lock mode set to manual:

       SELECT LOCK-FILE
          ASSIGN TO RANDOM SYLCKFIL-PATH
          ORGANIZATION IS INDEXED
          ACCESS MODE IS DYNAMIC
          LOCK MODE IS MANUAL
          RECORD KEY IS LOCK-KEY
          FILE STATUS IS LOCK-FILE-STATUS.

The declarative should be coded like the following example so the application code can intercept a lock condition and give the user the appropriate error message:

       LOCK-FILE-ERROR SECTION.
          USE AFTER STANDARD ERROR PROCEDURE ON
              LOCK-FILE.

Notice that there is no error procedure.

To lock the file exclusively, the file should be opened I-O with lock. This is the same as using LOCK MODE IS EXCLUSIVE in the Select statement.

       OPEN-LOCK-FILE-WITH-LOCK.

          PERFORM GET-PATH.
          MOVE PASSING-DATA-PATH TO SYLCKFIL-PATH.
          OPEN I-O LOCK-FILE WITH LOCK.

The file naming convention must be ??LCK??? and the length of the record must be 24 bytes for the file handler to recognize that a lock file is being processed.

CLS

    • Related Articles

    • Btrieve Error USE on COP Lock File

      Q - Today, for whatever reason, we experienced a large amount of locking issues in the warehouse. Several times today we ran into the problem with printing invoices where we received a message "Btrieve Error USE on COP Lock File," and it stops ...
    • Avalara Setup Procedures - System Requirements

      Release Date: 4/28/23 Version: 8.6 and Above Supported Version Avalara integration is only supported in Elliott version 8.6 and above. Versions 8.5 & 8.6 Running Side by Side Issues While we allow users running 8.5 & 8.6 side by side, if a user ...
    • AP07S1 Accounts Payable Cash Requirements Report

      Cash Requirements Report Application Overview The Cash Requirements Report can be used to determine, on a general basis, which invoices can be paid with the available cash or to determine exactly how much cash would be required to bring your A/P up ...
    • BM1100 Bill of Material Gross Requirements Report

      BM1100 Bill of Material Gross Requirements Report ← Bill of Material / Work Order Plus Gross Requirements Report Application Overview The Gross Requirements Report application prints a selected number of levels of components for a selected quantity ...
    • ARCUSMNT Accounts Receivable Customer File Maintenance

      Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...