Re: File transaction date

David,

Why don't you use a version of Dieter's trigger idea, but with a "additional
data" file that can be accessed with data from your main transaction file
(e.g., by transaction number). That way, you could use a trigger for
updating this file with the needed info (transaction number, mod.
date/timestamp, user, etc) and, for the few programs that need to use the
new info you could use a join file (trans. file + new file).

Later on, when you are ready for the big change, you can update your main
file info with the new file data.

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Fri, Nov 26, 2010 at 8:59 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Alan Campin

What you could do to mitigate the problem would be create
another library, modify the files and recompile all the
programs into this library and set up an install program to
move all the program and file in. That should mean you will
only be down for a short period of time.

Good idea for the long term, but for now I'm going to try a chgpf with
lvlchk(*no) with my new field added at the end. If that's not a good idea,
someone tell me quick!:-)
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.