Re: File transaction date

The journals will tell you who used a file and what programs but I don't
know if that is going to help you much. Based on what you are saying you
need exclusive access to the system for a period of 2.5 hours. Don't see
much way around that. You can use CHGPF to add the field without copying out
the data but if everything in the system is using the file and you hardwired
the record image into the module (Database independence again that one
thinks is important) then I don't see anyway around that.

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.

Anyway, just a suggestion. If this is a table you think you might end up
modifying again you might consider putting a field select logical; or
logicals on it so that you can change it in the future without recompiling
the world.

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

Hi,

I'm currently adding a date field to an old PF which will hold the date
that a transaction gets modified. The file has 3 or 4 mentions in different
RPG modules that get bound by copy to almost everything. This results in
having to recompile pratically the whole system. The job that migrates the
file takes about 2.5 hours to run and I need to plan it in advance so noone
is using the file when ir runs. In other words, it's a headache.

I don't know much about journals/receivers as they aren't used here. But
aren't they designed for this kind of information? I'm also thinking of the
rollback feature that they permit. I've never used that either. What kind of
preparations do we need to think about to be able to switch to this kind of
file management?


--
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.