cancel
Showing results for 
Search instead for 
Did you mean: 

How to join 3 tables from data base in sender JDBC channel in PI 7.4

former_member308994
Participant
0 Kudos

Dear All,

We have requirement, JDBC to RFC synchronous scenario.

we need to get the data from 3 different tables in data base.

My Question is

1. how to write a query in sender JDBC channel for joining three tables?

2. how to create structure for 3 tables in ESR level? Is it normal way or in different way?

3. How to update flag after successful updation in ECC?

Kindly help me on this .....

Thanks & regards,

Nagendra

Accepted Solutions (1)

Accepted Solutions (1)

former_member190293
Active Contributor
0 Kudos

Hi Ramu!

1. How do want to implement synchronous scenario using JDBC sender adapter? Do you plan to use adapter bridge?

2. If you want to join data from three different tables - you should use JOIN operator of SQL syntax. After execution SELECT command with JOIN operator on source DB you'll get the recordset containing fields from all the tables, so, in ESR you define a single message type of query result structure.

3. For updating the records after fetching you use UPDATE SQL command with the same filtering condition you've used in SELECT statement.

Regards, Evgeniy.

former_member308994
Participant
0 Kudos

Dear Evgeniy Kolmakov,

Thanks For your quick reply,

1. Using request response bean we will impliment syncronous scenario. we need to create one more JDBC channel to update records in DB while response.

Thanks & regards,

Ramu

Answers (0)