Query in IDOC To JDBC Scenario

[former_member190313]

hi all

below is my scenario :

As soon as vendor is created/ updated at R/3 , the IDoc is triggered via. change pointer , and is send to XI. XI will create / update the corresponding vendor in Oracle database at the pther side.

My question is , at Xi how will I come to know that the incoming vendor i have to insert in Oracle or update in oracle., as from XI i have to fire a query isert / update

thanks

Sheetal

[Former Member · Accepted solution]

Hi ;

Use UPDATE_INSERT as action .

action=UPDATE_INSERT

The statement has the same format as for the UPDATE action. Initially, the same action is executed as for UPDATE. If no update to the database table can be made for this action (the condition does not apply to any table entry), values of the table described in the <access> element are inserted in accordance with the description of the action INSERT. <key> elements are ignored in this case.

The response document has the following format; one of the two values is always 0 because either an UPDATE or an INSERT action is always executed:

<update_count>count</update_count>

<insert_count>count</insert_count>

Mudit

[former_member190313 · Accepted solution]

thanks for ur reply

it solved my problem

regards

Sheetal