Re: file changed

["Raul A. Jager W." <raul@xxxxxxxxxx>]

If the "update programs" are supoused to keep the files in sync, then 
referetial constraints will be excelent, they will cause to abort the 
program that is not doign the proper job, so you can correct it.

If you need to keep an eye without the user toticing, a trigger will do 
the job, every update will give you the opportunitty to check that 
record, and send you an alert if the change was incorrect.

Holden Tommy wrote:

> Read up on referential constraints.... 
>
>
> Thanks,
> Tommy Holden
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
> Sent: Monday, June 12, 2006 8:50 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: file changed
>
> HI We have a situation where I wrote an RPG program that checks the file
> integrity here between say our item's and the retailers (sometimes they
> want their item numbers in the EDI for example), so we have to keep trck
> of this relationship. My program checks several files to make sure they
> are in sync.
>
> Short of running my program every 15 minutes, what are some of the
> options
> for automatic checking and reporting to MIS and the users?
>
> As soon as something is out of balance, I would like to be notified.
>
> Thanks,
> Steve
>