I'm trying to write complex XML output using the XML output stage. The information comes from different tables (customer, address, contacts = phone numbers). Since addresses and telephone numbers can be mutiple for 1 customer, they must appear in repeating groups in the XML.
My question: how do I produce such an output? Given 1 customer, I could do a lookup for the addresses, but then I could get multiple results in the lookup, how do I merge them into the main customer flow to get 1 XML output message? Anyone with a good suggestion?
Thanks in advance, Paul Mulder
Complex XML output generation
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard, Paul.
Can you please confirm that you are using DataStage TX (also known as Mercator, also known as "transformation extender")? If you are using some other variant of DataStage, the answer will be completely different.
Can you please confirm that you are using DataStage TX (also known as Mercator, also known as "transformation extender")? If you are using some other variant of DataStage, the answer will be completely different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.