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?