Query from RDBMS Event generator
Posted on 2006-05-17
This is what I would like to do.
I want the Integration process to kick in as soon as a new row in a table called tableA is added. For this I have defined the channel rule in the RDBMS Event Generator.
So as soon as new row is added , I want to get the result of the query "Select * from tableB where id=1" and send it to the subscription method in my jpd.
How do I do this?
thanks in advance