Dear all,
This is my first work with the XML extenders: I'll have to decompose an
XML file into a DB2 table, and "flatten" it in the same time, like in
the example at the end of this message.
I need to do that on an iSeries with XML Extenders V4R5, but plan to
test it first on a Windows installation (DB2 Express, from the DB2 on
Rails installation http://alphaworks.ibm.com/tech/db2onrails/download).
1) Is the implementation the same on iSeries / Windows version? Can I
reuse the DAD file? Same command for decomposing?
2) I expect some particularities about flattening an xml file, and not
just decomposing in respective tables. Could you tell me what are the
tricky element about it, and maybe -that would be the most helpful!-
provide me with a "skeleton" DAD for the example below?
The reason for these "entry level" questions is -of course- limited
time frame to implement the thing :( ...
Thank you very much for any help!
* XML file with nested elements:
<container cID=1>
<item iID=1 val='A' />
<item iID=2 val='B' />
</container>
<container cID=2>
<item iID=3 val='C' />
</container>
* Target PF
container item value
1 1 A
1 2 B
2 3 C