mapping in RFC to JDBC

[mohammadaamir_khan]

Hi All,

I am working on RFC to JDBC scenario. My requirement is, when i am sending data using RFC, if particular line with same primary key, is already available in SQL database table, it should update otherwise insert the record. (Like modify statement with internal table in SAP ABAP).

I tried using UPDATE_INSERT but it is not giving desired result.

Please suggest hpw to do the mapping in ESR.

Thanks

[nabendu_sen]

Hi,

You can check the blog of Praveen. He has provided a lot details:

Regards,

Nabendu.

[former_member184720]

How did you define your structure in PI?update_insert should work..

Please check below blog and validate your strcture.

Defining an UPDATE_INSERT Statement - Configuring the JDBC Adapter in the Integration Directory/PCK ...

Document Formats for the Receiver JDBC Adapter - SAP XI: Runtime - SAP Library

[mohammadaamir_khan]

Hi Hareesh,

Can you please suggest hot to make data type for JDBC message. I tried in following manner, but KEY tag is starting after all the ACCESS tag.

<?xml version="1.0" encoding="UTF-8"?>

<ns1:MT_BMB_AREAS xmlns:ns1="http://area_client.com">

   <AREAS>

      <DB_TABLENAME action="UPDATE_INSERT">

         <table>Areas</table>

         <ACCESS>

            <Area_Code>12</Area_Code>

            <Area_Description>w42</Area_Description>

         </ACCESS>

         <ACCESS>

            <Area_Code>23</Area_Code>

            <Area_Description>w42</Area_Description>

          </ACCESS>

         <KEY1>

            <Area_Code>12</Area_Code>

         </KEY1>

         <KEY1>

            <Area_Code>23</Area_Code>

         </KEY1>

      </DB_TABLENAME>

   </AREAS>

</ns1:MT_BMB_AREAS>

[suman_saha]

Hi,

You may try the following tree structure :

DT_BMB_AREAS

      DB_TABLENAME    

          action

          access

               Area_Code

               Area_Description

          key

               Area_Code

Assign value for action as UPDATE_INSERT.

Try and let us know whether it works.

Suman

[former_member190681]

Dear,

what type of desired results you required?

for Desired Results you can use Stored procedure

Clearly tell me from the RFC to JDBC interface data is populating in databse or not?

if it is going what type of issue r u facing?

Regards,
Kiran Polani

[Former Member]

Hello,

Are you receiving any error? Which of the operations is failing insert/update or both?

BR,

Diptee