Page 1 of 1

Can we set trigger between Oracle table to db2 table

PostPosted: Tue Jun 28, 2011 8:13 pm
by ritikasingh
Hi Friends,

I have an Oracle database which is having online updates, also i have a db2 database same as Oracle.table defination is same.
Is there a possibility that if any update/insert happen in Oracle table a trigger is set at oracle so that DB2 tables also get the same insert /update automatically.So that i dont have to reate a process to capturing those inserts/update inflat file , ftpING TO DB2 SERVER from oracle, RUNNING JCL etc...

Re: Can we set trigger between Oracle table to db2 table

PostPosted: Thu Jun 30, 2011 1:04 pm
by GuyC
I know of the other way around and then only from DB2 LUW (of Oracle): nicknames

Re: Can we set trigger between Oracle table to db2 table

PostPosted: Wed Jul 13, 2011 2:46 pm
by GuyC

Re: Can we set trigger between Oracle table to db2 table

PostPosted: Thu Jul 14, 2011 7:59 pm
by ritikasingh
thanks Guy..this really helps!! :)