By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,279 Members | 2,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,279 IT Pros & Developers. It's quick & easy.

Decompose "leveled" XML to to one single PF ("flattened")

P: n/a
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

Jul 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.