Multiple UPDATE statement in a message

[Former Member]

Hi Experts,

Here is a scenario where we need to send multiple UPDATE statements in single message

the structure is as below.

<Table_name> 0..unbounded occurrence

<action> UPDATE

<access>

<non key fields>

</access>

<key>

<key fields>

</key>

in the above case the node <Table_name> would occur multiple times, the issue is only the first occurrence of the update statement is executed, rest of the update statements are ignored.

did my approach is wrong, please help...

thanks.

[Former Member · Accepted solution]

Bandana,

No your approach is not wrong. But you may need to tweak little bit to get your requirement correctly.

Please follow Raj or Jais reply in this threads:

But with this approach it would be multiple calls. If I were you I would write SQL_DML statement to update all at once.

Regards,

---Satish