on 10-11-2012 1:12 PM
Hi All,
In Idoc to Jdbc(receiver) scenario, is it possible to have structure for 'Merge' command? (as we have for insert/update/select/update_insert)
<StatementName1>
<dbTableName action=”UPDATE” | “UPDATE_INSERT”>
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2new</col2>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName1>
Like above structure, Please help me on the structure for merge command
Thanks & Regards,
Senthil J
Hi senthil,
i also think the same as baskar said jdbc statement structure does not supports merge command.
but i think you can go for procedure statement in which you can right a code for merge command.
Regards
Gagan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
AFAIK, I dont think jdbc statement structure supports merge command.
You can try this and see whether that works and let us know. I did not try before. Use the below sap link and see the statement6 structure where you say action ="SQL_DML" and pass your query that has merge in the access tag and see if that helps.
http://help.sap.com/saphelp_nw70ehp2/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.