Re: Updating a file while it is in use

[boothm@xxxxxxxxxxxxxxxxx]

I do not understand the issues here.  Why are you doing a cpyf? why not 
update the web file in-place? The users of the file are reading it only, 
so they won't be locking the file.   Is this an ideal place to use a 
dataque?
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"End of the Trail" <endofthetrail@skyenet.net>
Sent by: owner-midrange-l@midrange.com
04/14/2000 11:20 PM
Please respond to MIDRANGE-L

 
        To:     <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        Updating a file while it is in use

My trouble is....  I must update some files that feed web pages.  At this 
time, there is no set down-time for updates nor has the number of updates 
needed per day been set yet either.  The RPG and CL that rebuild the files 
can be call anytime. The data files will be rebuilt at different time 
during the day on a production box, transmitted to a web box(400), placed 
in a translib and then (if lucky)  CPYF with a *replace.  I cannot allows 
get a object-lock because people are on the page using the file.  I have 
though of keeping the new records in a file and doing a CPYF *ADD, but 
still need to update and/or delete exsisting records.  This could be done 
with a RPG program, but, even though the web pages are read only, it may 
set forever ( a long time ) with a wait for record lock. 
 
What are the thoughts of the knowlegde base?  Any tricks or suggestions?
 
Eurrat



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---