Sender JDBC Adapter : Fetch records from multiple tables

[former_member183910]

Hi Friends,

I am using sender JDBC adapter to select few records from DB2 database table.

This scenario is working fine.

Now my requirement is to fetch records from 3 tables. These table are independent to each other. There is no primary key or foreign key.

Please let me know how to write the sql in sender JDBC adapter to fetch records from these 3 tables.

Thanks,

Sandeep Maurya

[Former Member · Accepted solution]

Hi Sandeep,

Pls find the below link which may help resolve your problem.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/30dd49da-a6ac-2a10-23bf-d0d58b2532dd

Thanks and Regards,

GP

[Former Member]

Hi,

I prefer going for a stored procedure,which will fetch the data from all the three tables based on ur requirements.

And call that stored procedure from the sender JDBC adapter.

Going for JDBC lookup's will add extra overehead on PI

Bbau

[former_member183910]

Thanks friends.

[former_member206760]

hi sandeep...

if the tables are completely independent and do not share any primary / foreign key relation ship...

why dont u think towards creating a seperate interface for each of them..

or if u still want to select from multiple table at once..the best way would be to write a stored procedure on the sender side which do all the fetching n processing and pass the final resultset to PI

or u can think towards fetching the data from 1 table and then in UDF do lookup from other tables..which again is tricky and performace intensive