XML Output File Generation

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Suma Reddy
Participant
Posts: 7
Joined: Mon Oct 30, 2006 12:19 am

XML Output File Generation

Post by Suma Reddy »

Hi,

I need to generate a xml file in the following format.

Expected File:

<Body><Profile><EmpId>123</EmpId><NameInfo><NameType>Legal</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo><NameInfo><NameType>NickName</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo></Profile></Body>

The output what i am getting is :

<Body><Profile><EmpId>123</EmpId><NameInfo><NameType>Legal</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo></Profile><Profile><EmpId>123</EmpId><NameInfo><NameType>NickName</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo></Profile></Body>

I have given "NameType" as key column while generating the xml.Please suggest what to do inorder to get the expected ouput.

Thanks,
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”