Midrange News for the IBM i Community

Posted by: seewiz
Multiple member file and record locks
has no ratings.
Published: 10 Jan 2013
Revised: 23 Jan 2013 - 2187 days ago
Last viewed on: 16 Jan 2019 (3213 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Multiple member file and record locks Published by: seewiz on 10 Jan 2013 view comments(6)

Our BOM is a multiple member file.  A new member is downloaded every night.  We have a program that when the users are ready, they can make the new member the "current" member.  All the other programs that access this file use the "current" member in the processing.  The only programs that open this file with an update/add are the programs related to making the new member current. 

We have many other programs that access the BOM through embedded SQL or regular file specs of IF not UF.

The other programs lock the BOM so we cannot change the current member when other people are in these programs. 

Is there anyway around this problem?  We are running into the problem of having too many people accessing the BOM during the time the users need to make the BOM current.


Return to midrangenews.com home page.
Sort Ascend | Descend