DS rollback and triggers

[stivazzi]

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.

[ray.wurlod]

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.

[Sreenivasulu]

DESIGN suggestion-

You can write a DS job which would poll the source table which is expecting a change. This DS job would be polling at a periodic interval
with the help of a sequencer. Once a change occurs a set of jobs can be run. This way you can simulate a trigger.


Regards
Sreeni

[ray.wurlod]

Have you considered a solution involving database replication services?

[sb_akarmarkar]

You can also try with Database link between db1 and db2
Try the query with Begin ... End.

I hope that will help you but i am not sure.

Thanks,
Anupam