RE: catch table changes

Csaba Kabai
Are your tables journaled?
You could extract the journal entries to a report or another table or even
another database.

If you subscribe to www.iseriesnetwork.com - search for 'Journal Browser'
Hope it helps
Shreya

-----Original Message-----
From: Patrick L Archibald [mailto:Patrick.Archibald@xxxxxxxxxxxxx] 
Sent: 25 March 2004 12:56
To: Java Programming on and around the iSeries / AS400
Subject: Re: catch table changes

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


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


---------------------------------------------------------------------------------------------
Registered Office:
Siemens Financial Services Limited (Tel: 020-8422 7101)
160 Northolt Rd, Harrow, Middlesex (Fax: 020-8422 4402)
HA2 0PG 
Registered No: 646166, England
Web:www.siemensfinancialservices.co.uk
---------------------------------------------------------------------------------------------

***************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
***************************************************