cancel
Showing results for 
Search instead for 
Did you mean: 

creating multiple update_insert statements

Former Member
0 Kudos

Hi

I am creating multiple update_insert statments by repeating the statement node in the receiver jdbc structure...

Will I get a single response XML message with the update count for all the insert statements or will i get separate response message for each statement.

Also how do i find out which response is for which statement as the response message normally contains only one field <update_count>0 updated succesfully</update_count>

Thanks

Jyoti

Accepted Solutions (0)

Answers (3)

Answers (3)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Even if your target structure has multiple inserts/updates , you package it in one request structure as a single call.  The response structure will be a single call for the total updates. Please remember that.

ambrish_mishra
Active Contributor
0 Kudos

Hi Jyoti,

I would say give it a try.

If it does not work and you do want multiple responses, then you can have a go at multi-mapping.

Ambrish

Former Member
0 Kudos

Hello,

No i don't think that u will get separate response message for each statement (update_insert)...all the update count will be returned under the single response field and the same holds true for insert also.

Thanks

Amit Srivastava