I'm having a problem with the XML extender for DB2. I have an XML file and I was to decompose it to DB2 (one way transfer). So I've tried to create a DAD file to do this. My issue is that in all XML extender examples they always use an Attribute as the primary key! Is there anyway around this? i'd like to use an element as a key instead but it wont let me and the result is it creates n rows for every n <element_nodes> that I have.
example case that I have which doesn't work.
<id>111</id> <-- want to set this as PK
example case which DOES work:
I have no control over the format of the incoming XML so using the 2nd example isn't an option. Is there anyway I can set the <id> tag to be the key in the DAD file instead of using the <attribute> tag?
I'd appreciate any help on this issue, and I can clarify if this doesnt make sense. Please help if you have knowledge on this subject, thanks so much.