Skip to Content

JDBC Multiple tables to Proxy scenario

Sep 27, 2017 at 07:08 AM


avatar image
Former Member

Hi Gurus,

I have two tables in oracle system and i need to send the data to SAP ECC.

And the tables are having three what is better whether to write join query or

Stored Procedure in jdbc sender comm channel.

What will be my JDBC Sender structure it will be combination of both the columns of two tables or what

Please suggest how to implement.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Sep 27, 2017 at 08:05 AM

Hi Sai!

If you need to fetch the data from one table along with additional data from another table which is linked to your main table - you could use Select statement with Join condition to get columns from both tables in one result rowset. And in Update statement you should update the selected records by setting some status in main table to prevent its processing with next query.

Regards, Evgeniy.

10 |10000 characters needed characters left characters exceeded