Topic
  • No replies
VV4H_mario_fernandes
43 Posts

Pinned topic update a xml column

‏2011-12-12T16:44:39Z |
Hi

Can you please let me know an sql that will update a xml column
I am using db2 9.7 on Linux
The table contains a single XML column.

The tag I want to replace or create is <sendingProcessName>.
If it exists I want to replace its value
If it doesnt exist I want to create it

Is there a single xpath query that does this?
<kasperSchema>
<TDSClient>
<VenomJmsMessage>
<sendingProcessName>
BATCH
<sendingProcessName>
</VenomJmsMessage>
</TDSClient>
</kasperSchema>