Good morning to everyone...
i'm totally newbie about DS, and i'm trying to understand how to use it.
in particular, i got 2 problems:
when some modifications happen in db1, i should send them to db2(1st question: how can i start a trigger?);
again... i have 2 tables on db1, i have to copy records into 2tables with same structure in db2. but i don't know how... from table to another table1 in 2 different db it's clear (table>transformer>table 2)... but from 2 2 tables to 2 tables?
if the second transaction fails i should perform a rollback of first transaction, but... how can i tell DS to wait for performing a commit?
i hope i explained myself
thanks a lot
A.
DS rollback and triggers
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
How do you detect that a change has occured in db1? What kind of change detection mechanism do you use? Have you implemented triggers in db1? If so, can a trigger invoke an operating system command?
To insert rows into two tables as a single transaction, you can use an ODBC stage with two input links (one for each table), and specify that the stage is to use transaction grouping. How you co-ordinate from the two source tables is a matter of design for you to resolve, and will depend on the relationship - if any - between rows in the two source tables.
How do you detect that a change has occured in db1? What kind of change detection mechanism do you use? Have you implemented triggers in db1? If so, can a trigger invoke an operating system command?
To insert rows into two tables as a single transaction, you can use an ODBC stage with two input links (one for each table), and specify that the stage is to use transaction grouping. How you co-ordinate from the two source tables is a matter of design for you to resolve, and will depend on the relationship - if any - between rows in the two source tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact: