on 03-15-2018 7:22 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.