SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:36 AM
| ||||
| ||||
 Decompose "leveled" XML to to one single PF ("flattened") 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      |
Linear Mode
