JDBC Adapter

[Former Member]

Hi, expertsI need your opinion on the following topic.

Table A contains the headers, table B contains concepts of headers in table A and table C contains details of concepts in table B. the relationship between headers and concepts is 1:N, and the relationship between concepts and details N:N. I need to join them through SAP PI by a Sender JDBC Adapter.

I´ll be very grateful to hear your suggestions, Thank you.

[Former Member]

Hi,

can u brief ur requirement and also is there a common field in all three tables...

[former_member181962]

Hi,

I would prefer a stored procedure or function on the sender side:

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Best Regards,

ravi