hello gurus,

I have the following problem ... can anybody help

1. application - APP1 is running on DB2 UDB
2. application - APP2 is running on SQL SERVER.

now , APP1 insert/updates few datas in few tables that needs to be inserted or updated thru a automated process (like trigger ...)

can anybody suggest how the data can be passed thru between two database thru a automated process ?

at 1st i thought of trigger calling sp but DB2 Dosnt support that ...

any suggestion will be highly appcted.

best regards

Did you try db2 information integrator, which uses federated access to the external database?

http://www.db2mag.com/story/showArti...cleID=15300103