Re: catch table changes

[Csaba Kabai <cskabai@xxxxxxxxxxx>]

>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