RE: File field maintenance logging

There are many reasons I am thinking of this approach. I did not list them as that was off topic as to what my main question was.
Some of the reasons are that I need to protect some fields and/or records from users that do not have authority to view them.
I need to do field level logging as most records do not contain last change info even on the rows.

Journaling will certainly do the logging I want but will not accomplish the protection.
The code running here is circa 1992 with all pgms doing the get/display/update and is updating vendor files.
I am just playing around trying to separate the get/update (for now) to hopefully get it to the point where I can start playing with different from ends. The method of update either std rpg or sql is not the question.

This is a start of a attempt of moving ALL the home grown code to a better design. This will be a large project but my intent is to do things correctly for the next 20 years. Having the file updates separated from the display and business logic is the correct way to go.

Hi All,

I want to create a "new" standard here in which all access to a file (Inquiry and Update) are done through a single pgm.
Let's call it FMMasterR for file MASTER.
My display pgm gets the record from FMMasterR. It is maintained and
returned to FMMasterR as a DS (Parm_DS). I chain to MASTER receiving it into a Old_DS. I can compare Parm_DS to Old_DS to see that something changed. I can get the field names in the file easy enough loading into an array. What I want to do spin through the fields finding what changed. Something like If Parm_DS.Field(1) <> Old_DS.Field(1). I then can write to a maintenance log of specific field changes. I know someone does field level maintenance logging so I am looking for some guidance on the best approach. Being I have the fields, length and pos I suppose I could try and compare doing a substring on the entire length of the file.
I am just playing and trying to come up with some ideas.

Subject to Change Notice:

WalzCraft reserves the right to improve designs, and to change specifications without notice.

Confidentiality Notice:

This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You;

WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
www.walzcraft.com Phone... 608-781-6355