how to read xml file in Datastage

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
tanmaya
Participant
Posts: 38
Joined: Tue Jun 16, 2009 7:57 am
Location: Bangalore

how to read xml file in Datastage

Post by tanmaya »

Hi,

I have an xml file in my server which I need to use as a source for the input to the webservices transformer used in my job.

I need to ask that whether is there any stage in datstage to read the xml file. What I mean here is that for reading text files or csv files we have SEQUENTIALFILESTAGE, so please let me know if there is any stage using which I could read xml file.
It is urgent.

Please respond.

Thanks in advance

Tanmaya
sankar.td
Participant
Posts: 42
Joined: Fri Jul 25, 2008 3:53 am
Location: pune
Contact:

Post by sankar.td »

Hi ,


There is XML Input and Out put stages are there in "REALTIME" Tab.

Using those stages we can retrive data from XML Sources.

these links may help ful to you.

http://download.boulder.ibm.com/ibmdl/p ... _0508I.pdf



http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP
sa
tanmaya
Participant
Posts: 38
Joined: Tue Jun 16, 2009 7:57 am
Location: Bangalore

Post by tanmaya »

sankar.td wrote:Hi ,


There is XML Input and Out put stages are there in "REALTIME" Tab.

Using those stages we can retrive data from XML Sources.

these links may help ful to you.

http://download.boulder.ibm.com/ibmdl/p ... _0508I.pdf



http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

Hi Sarkar,

Thanks for the help,but I dont need to convert xml to tabular data. It is that i just need to read an xml file as it is and then pass the exact file to the web service transformer. This is because the web service transformer needs the data in the xml format only not in the tabular format.

The xml input and output stages just covert from tabular to xml and vice versa respectively. i dont need any modification.

please let me know if you anything like this.

Tanmaya
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Read it with the Folder stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply