I need advice on the best way to handle the following file update scenario:
File A: Contains temporary records that track all transactions associated with a request.
File B: New file will provide a permanent record of several fields from File A. The data in this file must mirror data from File A as it is generated/updated.
There are about 5 pgms that routinely update File A. Should I:
1. Compare these fields in the update routine of each pgm, open File B & write/update changes?
2. Compare fields & call a single update pgm from all 5, passing changed data in parameters?
3. Call an update pgm from all 5 that opens both files & writes/updates fields from the appropriate record from File A into File B.?
4. Other?
Assuming that I can't use triggers or modular programming which solution makes the most sense? Thanks for your help.
File A: Contains temporary records that track all transactions associated with a request.
File B: New file will provide a permanent record of several fields from File A. The data in this file must mirror data from File A as it is generated/updated.
There are about 5 pgms that routinely update File A. Should I:
1. Compare these fields in the update routine of each pgm, open File B & write/update changes?
2. Compare fields & call a single update pgm from all 5, passing changed data in parameters?
3. Call an update pgm from all 5 that opens both files & writes/updates fields from the appropriate record from File A into File B.?
4. Other?
Assuming that I can't use triggers or modular programming which solution makes the most sense? Thanks for your help.