Audit trail of masterfile changes

[Paul Howard]

Hi Cliff,
How about having an alias of the master file as a reference file.
Then in the preupdate procedure you have before and after images available.
Still quite a lot of work to do but at least it is better than messing
around with edit procedures.
Paul

-----Original Message-----
From: Art, Clifford [mailto:cart@metropolitan.co.za]
Sent: Friday, May 07, 1999 12:11 PM
To: 'POWERH-L@lists.swau.edu'
Subject: Audit trail of masterfile changes


Anyone have a low maintenance method of writing audit trail records to a
file when users update masterfile records.
We want to keep the following info on a file so the users can see it:
user
date
time
masterfile name
masterfile field
changed from
changed to

We currently call a cobol program in the pre-update procedure passing the
masterfile record.
The cobol program reads the original record and compares all the fields one
by one writing 
the audit trail records. It works but is a lot of work to maintain as our
masterfiles are
constantly changing.

The audit file option doesn't seem to help as it only stores an after image
of all the fields changed.
Anyone have a better, preferably low maintenance way of doing this...

PH 7.29.C5 on MPE/iX

Thanks
Clifford Art
cart@metropolitan.co.za

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.