Create report in RPG for Jounaled PF
Hi
Is there quick way to generate report for the changed fields in a jounaled PF. I have a PF which has over 50 fields and need to produce a report if any field is changed or added new value.Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
August 29, 2008 7:23 PM
UPDATED:
August 29, 2008 10:17 PM
Answer Wiki:
I don't believe this will be easy but if you are capturing before and after images then it's not as bad as it might be
1. You will have to use DSPJRN to write the entries to a DBF (called DSPJRN below)
2. Your program needs two externally defined datastructures based on the file in question
BeforeDS with prefix 'B_' and AfterDS with prefix 'A_'
3. read the before and after records from DSPJRN moving one to beforeDS and the other to afterDS
4. Write the code to compare any b_ fields with the a_field and report the differences.
This is the procedure for a change, a write will only have an after and a delete will only have a before.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
