DB2 ESE 8.2 AIX
The XML Document stored in column j in table xmle(i int,j xmlclob) is
<xmldoc><ele1><ele2 att1="A11" att2="A12">eleval1</ele2><ele2 att1="A21" att2="A22">eleval2</ele2></ele1></xmldoc>
The result expected is
A11 A12
A21 A22
I have tried a couple of things including the usage of db2xml.extractchars(xmle.j,'/xmldoc/ele1/ele2/@att1').
I do not seem to find a function which could extract all the attribute values of a particular element as a row.
(There may be more than two attributes to extract).
Can someone help, please?
Thanks in advance.
Sathyaram