How to load txt file into XML file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
mohandl
Participant
Posts: 43
Joined: Tue Dec 26, 2006 7:01 am
Location: pune

How to load txt file into XML file

Post by mohandl »

Hi all,

My requirement is to load txt file into XML file ,if any one knows please explain me the steps.

Thx and Regards,
Mohan
MOHAN
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Set up the XML metadata first. You may wish to use a style document, you may wish to edit the XML metadata manually to specify namespaces and the paths that describe the XML structure.

Read the text file with a Sequential File stage, pass it through a Transformer stage (so you can Monitor), then through an XML Output stage and then whatever you want to do with the XML.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

That is a very vague question. In the simplest case you can map straight from text file to XML. Could you post what you have tried already and which problem you have encountered?
Post Reply