Skip to Content
0
Former Member
Nov 03, 2012 at 11:37 AM

how to update and insert records at Db side

27 Views

Hi Experts,

i am doing proxy to Jdbc scenario. we are getting 20 records form SAP to PI and PI those records to DB. 20 records are unique keys.here we are using if the is record there at db side we are going to update and no records are there at db side we are going to insert record. by achieving this we are using Update_Insert query in action. below is my receiver structure.

statement 0.1

emp details 1.1

action

table

access

field1

field2

key

field3

field4

in sender side we have structure like root node under fields. here my doubt is how we can map.

1. if we mapped root node to root node the action will be executed 20 times or single time.

2. if we mapped sender root node to access elements if the record is there at db side update is executed. at the time update the record or it getting any error.

please help me on this how the update_insert query works at db receiver side. appreciate your help.

Best Regards,

Sanjay.