Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replication Question
- Thread starter lynchdog
- Start date
sathyarams
IS-IT--Management
I don't think there is a direct method ..
A thought ..
ST1 - source table
CDT_ST1 - change data table of ST1
CDT_ST1_VIEW1 - view of CDT_ST1 useful columns where operation='I'
CDT_VIEW1 - change data of view1
Define ST1 adn CDT_ST1_VIEW1 as the replication source
When data is changed in ST1, it will write to the CDT .. the view cdt_st1_view1 will have only inserts and hence CDT_VIEW1 will have all inserted records of ST1
Use CDT_VIEW1 as your soruce when you define subscription
Probably there are better methods ...
Cheers
Sathyaram
For db2 resoruces visit More DB2 questions answered at
A thought ..
ST1 - source table
CDT_ST1 - change data table of ST1
CDT_ST1_VIEW1 - view of CDT_ST1 useful columns where operation='I'
CDT_VIEW1 - change data of view1
Define ST1 adn CDT_ST1_VIEW1 as the replication source
When data is changed in ST1, it will write to the CDT .. the view cdt_st1_view1 will have only inserts and hence CDT_VIEW1 will have all inserted records of ST1
Use CDT_VIEW1 as your soruce when you define subscription
Probably there are better methods ...
Cheers
Sathyaram
For db2 resoruces visit More DB2 questions answered at
- Status
