IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Can we set trigger between Oracle table to db2 table



IBM's flagship relational database management system
Post a reply

Can we set trigger between Oracle table to db2 table

Postby ritikasingh » Tue Jun 28, 2011 8:13 pm

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...
ritikasingh
 
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Has thanked: 0 time
Been thanked: 0 time
Top

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

Postby GuyC » Thu Jun 30, 2011 1:04 pm

I know of the other way around and then only from DB2 LUW (of Oracle): nicknames
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times
Top

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

Postby GuyC » Wed Jul 13, 2011 2:46 pm

http://www.zseriesoraclesig.org/2005pre ... oracle.pdf
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times
Top

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

Postby ritikasingh » Thu Jul 14, 2011 7:59 pm

thanks Guy..this really helps!! :)
ritikasingh
 
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks