|
This sounds like a case for journaling. Then use the journals to create your report. Sharon -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of "Tomasz Skorza" Sent: Wednesday, March 21, 2007 10:40 AM To: midrange-l@xxxxxxxxxxxx Subject: Tool for tracking changes in file Hi I need a program which will track all changes made by program/s in database on AS400. Explanation: 1)I call PGM1 A) program PGM1 change REC1 in FIL1 - info about it (what was changed) should be store somewhere) B) program PGM1 change REC2 in FIL2 - info about it (what was changed) should be store somewhere) C) program PGM1 change REC1 in FIL1 - info about it (what was changed) should be store somewhere) 2) program PGM1 call PGM2 A) program PGM2 change REC1 in FIL3 - info about it (what was changed) should be store somewhere) 3) program PGM2 call PGM3 A) program PGM3 change REC1 in FIL1 - info about it (what was changed) should be store somewhere) B) program PGM3 change REC1 in FIL4 - info about it (what was changed) should be store somewhere) Report should show PGM1 change REC1 in FIL1 PGM1 change REC2 in FIL2 PGM1 change REC1 in FIL1 PGM2 change REC1 in FIL3 PGM3 change REC1 in FIL1 PGM3 change REC1 in FIL4 Because I don't exactly know which files can be changed - It will be fine to "register tracking by program dependence" not by files. Do you have any idea which program support such job? Regards Tomasz
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.