Skip to Content
avatar image
Former Member

JDBC Multiple tables to Proxy scenario

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 columns.so 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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded