RE: catch table changes

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

Csaba,

Can you explain what you mean by "other file manipulations are delimited" in
relation to triggers.

Cheers
Colin.W

 


-----Original Message-----
From: Csaba Kabai [mailto:cskabai@xxxxxxxxxxx] 
Sent: 29 March 2004 14:16
To: java400-l@xxxxxxxxxxxx
Subject: Re: catch table changes






>If you could give us a little more information about what you are 
>trying
to
>accomplish, we can probably give you better answers.

Dear Chris,

In summary, what i want to solve:

I try to accomplish that if on the AS400/DB2 table has changed, (INSERT,
UPDATE, DELETE) these events publicated to a DATAQUEUE. On the other side of
the queue there is a Java program which is receiving the information. Based
on these entries,  another database tables (MSSQL) be inserted, updated,
deleted. Doing this work with triggers is unacceptable, because if there is
a trigger on the table, other file manipulations are delimited. At the
present time, i can read/write the queue with java to propagate the changes,
but can't catch the table change event (maybe signal?), only to frequently
query the tables.

I know, that there is a great solutions for the problem, such as
DataPropagator, Host Integration Server etc, but we are thinking of a
'cheaper' way. :(

I see, the problem is not as simple as the first sight. Unfortunatelly, the
traditional host languages, like COBOL, RPB is difficult to start learning.
Java has opened the "black box" for me, but not wide enough.

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 e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.