on 01-08-2010 3:33 PM
Hello All,
I have a scenario - Web Service (async) -> PI -> JDBC (Sync).
I have 2 different SELECT statements to run. Is it possible to do that in the message mapping? If yes, what will be the data structure format?
Also, in case it is possible to execute 2 different SELECTs, what will happen for the response? As you have noticed, I will be getting back response. I am using BPM for A-S bridge.
Any help will be highly appreciated.
Thanks,
Abhi
Yes you can have multiple statements with in the single message.
Q: I have 2 different SELECT statements to run. Is it possible to do that in the message mapping?
A: Yes you can have multiple statements with in the single message.
Q: If yes, what will be the data structure format?
A: Please refer the structure mentioned in the link... you have to create multiple statement structures
http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
for example:
<Message>
<StatementName1>
<dbTableName action=u201DSELECTu201D>
<table>realDbTableName1</table>
<access>
<col1/>
<col2/>
<col3/>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName1>
<StatementName2>
<dbTableName action=u201DSELECTu201D>
<table>realDbTableName2</table>
<access>
<col1/>
<col2/>
<col3/>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName2>
</Message>
Q:Also, in case it is possible to execute 2 different SELECTs, what will happen for the response? As you have noticed, I will be getting back response. I am using BPM for A-S bridg
A: Response will come in single message
As for the above request ...the reponse will be like the ...
<Message_response>
<StatementName1_repoonse>
<col1/>
<col2/>
<col3/>
</StatementName1_response>
<StatementName2_repoonse>
<col1/>
<col2/>
<col3/>
</StatementName2_response>
</Message_response>
Regards
Sunil.
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.