Sender JDBC fetching of data

[Former Member]

Hello,

I have a query regarding Sender JDBC adapter.

1)Can i use it for querying 3 tables at a time? I am not considering of using stored procedure at the moment.

2)If the query is successful, i will have multiple rows as my data. Then for a particular row of data, can PI handle multiple values for a particular field in sender JDBC? If so, how does the data type look? Please help ..

[rajasekhar_reddy14]

You can try using Join statement or stored procedure to achieve your requirement however follow better design like creating one intermediate table .

Intermidiate table should have data from 3 tables and poll JDBC adapter to intermediate table.

Moving data from 3 tables to intermediate tabel handle using SP at DB level.

[Former Member]

Hi Raja,

But my other query is, whether SAP PI will be able to handle multiple results for a particular field in my sender data type?

[baskar_gopalakrishnan2]

I believe you refer multiple resultsets for a particular field in the table. Yes it is possible.