Topic
3 replies Latest Post - ‏2011-12-12T18:13:46Z by MatthiasNicola
VV4H_mario_fernandes
43 Posts
ACCEPTED ANSWER

Pinned topic update a xml column

‏2011-12-12T16:44:46Z |
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>
Updated on 2011-12-12T18:13:46Z at 2011-12-12T18:13:46Z by MatthiasNicola