Query from RDBMS Event generator

Posted on 2006-05-17
Last Modified: 2013-12-10
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
Question by:expertsit
    LVL 10

    Accepted Solution


    why don't you execute your query with a database control directly after receiving the first message (insert into table A) ?


    Author Comment

    Excellent idea! Let me try that.


    Author Comment

    That worked.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
    There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now