Re: catch table changes

[Patrick L Archibald <Patrick.Archibald@xxxxxxxxxxxxx>]

Csaba Kabai


Are you looking nightly report of changed tables or something more 
immediate?  I just wrote an application that sends emails nightly when 
certain tables change. The email included the records added, deleted 
and/or changed.

Thanx, PLA



Csaba Kabai wrote:

> Dear All,
>
> I'm searching the way to write a program which is track changes of the
> V4R5M0 AS400/DB2 tables ,
> such as INSERT, UPDATE, DELETE and write these entries to a list (table).
> I think the database monitoring is a resource intensive solution and we
> don't want to create triggers for each
> effected tables. ;) It's possible to write a "service" which do the work?
>
>
> Thanks,
>
> Csaba Kabai
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>