on 12-17-2009 8:27 AM
Hi,
I am having a requirement like, i need to fetch the data from two data base tables. and after fetching the data, i need to update those two tables.
For selecting the data from two tables, two select statements i need to write, how i can give two select statements in sender JDBC comm channel.
In sender JDBC channel, only one update query we can give...how i can update two tables?
Regards,
Venkata Ramana.
Hi,
Check if there is any common field and based on which you can write some query for fetching the needed data..
or try use the joins...and use the same statement at update tab also for updating the both tables data...
just use the same query as how it can be used at database level
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkata,
You can fetch the data from two tables using join query in sender JDBC communication channel.
But for this, there has to be at least 1 field common between two tables to evalueate the condition.
Also, while updating both the tables, you can create 1 such a structure comprising those fields from both the tables which needs to be updated, and using mapping program you can update them back to sender.
-Tanaya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkata,
>>i need to fetch the data from two data base tables. and after fetching the data, i need to update those two tables.For selecting the data from two tables, two select statements i need to write, how i can give two select statements in sender JDBC comm channel.
You cannot do this in sender jdbc adapter. It supports only one query at a time.. So either go for Stored Procedures or Some complex query like union or create a view out of this two tables and query the view..
>>In sender JDBC channel, only one update query we can give...how i can update two tables?
Again this cannot be done....go for BPM and complete your scenario...
Regards
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkata,
Using BPM with Fork and receive steps.. something like this:
http://wiki.sdn.sap.com/wiki/display/BPX/BPMPatternMultiIfconditionExplained%28stepbyStep+Procedure%29
/people/milan.thaker/blog/2008/07/23/correlation-150-runtime-behavior-of-bpm
Regards
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.