Hi,

I'm working in DB2 v9 for z/OS, I've seen that it exists a XMLMODIFY command in DB2 V10 and I would like to simulate this function in DB2 V9.

Here is an example. I would like to modify the value of the <Amt> tag (changing from 0.000 to 1000) where the tag <Tp> = 'XXXX'

<Stmt>
<tag1>00111</tag1>
<tag2>AAAAAAAA</tag2>
<Ccy>003</Ccy>
<Bal>
<Tp>XXXX</Tp>
<Dt/>
<Amt>0.000</Amt>
</Bal>
<Bal>
<Tp>YYYY</Tp>
<Dt/>
<Amt>0.000</Amt>
</Bal>
</Stmt>

An idea for me ??
Thanks
Roc