Is it possible to use the old and new field information in an sql trigger?
Might be easier than writing all file access to go through one pgm.
Steve
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
(WalzCraft) Jerry Forss
Sent: Friday, August 01, 2014 8:52 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
(rpg400-l@xxxxxxxxxxxx)
Subject: File field maintenance logging
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.
Thanks!!
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<
http://www.walzcraft.com/> Phone... 800-237-1326
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
