A pretty straightforward XML question
Posted: Tue Apr 24, 2012 3:27 pm
Hello;
Reading in hierarchical XML (from an ISD or flat file) and running through any of the available 8.7 XML stages, at some point when I connect to another stage all of the fields need to be explicitly defined.
That being the case, is there any mechanism in 8.7 to handle repeated XML nodes of an unlimited number? For example, if a customer record could have unlimited phone numbers - is there a way to recognize and process all of them?
I believe I need to explicitly declare PHONE1, PHONE2, etc columns out of my XML stages, which obviously limits me to the number I've chosen to define. Is there any way to correctly handle such truly unlimited XML nodes in 8.7?
While I'm quite familiar with Datastage, I've only recently started using XML. Since last week I've been playing around as well as reading a lot of postings and IBM documents; and from what I can tell there simply isn't a way to do this. Which frankly I didn't think there would be, but I though I would pose the question before I gave up completely!
Any suggestions (not looking for details, just to be pointed in the right direction) or comments are greatly appreciated.
Thanks for your time,
Richard C.
Milwaukee, WI
Reading in hierarchical XML (from an ISD or flat file) and running through any of the available 8.7 XML stages, at some point when I connect to another stage all of the fields need to be explicitly defined.
That being the case, is there any mechanism in 8.7 to handle repeated XML nodes of an unlimited number? For example, if a customer record could have unlimited phone numbers - is there a way to recognize and process all of them?
I believe I need to explicitly declare PHONE1, PHONE2, etc columns out of my XML stages, which obviously limits me to the number I've chosen to define. Is there any way to correctly handle such truly unlimited XML nodes in 8.7?
While I'm quite familiar with Datastage, I've only recently started using XML. Since last week I've been playing around as well as reading a lot of postings and IBM documents; and from what I can tell there simply isn't a way to do this. Which frankly I didn't think there would be, but I though I would pose the question before I gave up completely!
Any suggestions (not looking for details, just to be pointed in the right direction) or comments are greatly appreciated.
Thanks for your time,
Richard C.
Milwaukee, WI