Structure for 'merge' command - jdbc receiver

[Former Member]

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

[gagandeep_batra]

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

[baskar_gopalakrishnan2]

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