Skip to Content
0
Former Member
May 13, 2016 at 01:48 AM

JDBC Sender: Reading from two different Tables with one Stored Procedure

175 Views

Hello All,

Currently i have a JDBC to RFC scenario where the sender JDBC adapter has to read data from two different tables and populate data using stored procedure. The question i have is that when i read the data using stored procedure, i would be getting different data from two different tables and how should we create the data structure in this case. In a normal case we give a DocumentName parameter to define the recordset, but here i would be getting two different recordset.

For example, say i have the below two tables

Table1:

EmpID

EmpName

Location

Table2:

Company

Address

How should we create the data structures and is there any specific config that is required in Sender JDBC channel ?