Re: Triggers for catching updates

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 11:03 AM 7/8/97 +0200, you wrote:
>Hi!
>
>We are new to usage of triggers on the AS/400 and want to them for catch 
>changes on varoius tables to support the update for a data warehouse 
>(using a DB2 common server on NT or SUN). The question we have is, 
>which is the most easiest way to write the changed record into an 
>additional file. On an abstract level something like
>ON INSERT or UPDATE of <file>
>INSERT <record> INTO <file>CHG
>
>Do we have to code this in RPG/C/COBOL (as it is shown in ONLINE Library) or 
>are there more simpler ways around? 
>

I had a model trigger program published last year in a publication called
'Inside V3R1'.  You can contact The 400 Group at 617-444-5755.  The code
that you are talking about doing is not hard to write.

Alternatively, Data Mirror (Canada) has a product that does this today,
based on journaling.  This likely will have less AS/400 CPU overhead.
Mimix is expected to have a comparable product within a year.

Al

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *