Datastage XML

kogads · Post by **kogads** » Sat Sep 10, 2011 8:54 pm

Can anyone explain how to read xml files in Datastage parallel jobs , i saw a lot of posts which mention how to output to xml stage and also reading through a folder stage in server jobs but i dont see how to read xml files in parallel jobs any where ... any help is appreciated .Thanks

chulett · Post by **chulett** » Sat Sep 10, 2011 10:02 pm

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

prakashdasika · Post by **prakashdasika** » Sun Sep 11, 2011 8:16 pm

You can use a external source stage as specified by Ernie in his blog or do the same thing using a wrapper stage (custom stage) and do a 'ls' to get the xml file and in the input tab of XMLInput stage select the source as 'URL/Path'.

If the name of file remains same then you can also have a transformer with a column that contains the path (including the name of the file) which will be input to the XMLinput stage. This stage should also have a dummy Row Gen stage.

Ravi.K · Post by **Ravi.K** » Tue Sep 13, 2011 10:04 am

Use the below thread for XML file reading at Parallel Jobs.

viewtopic.php?t=138188&highlight=XML

FranklinE · Post by **FranklinE** » Tue Sep 13, 2011 3:05 pm

Ravi.K wrote:Use the below thread for XML file reading at Parallel Jobs.

viewtopic.php?t=138188&highlight=XML

That was the exact thread I found and used to help me get started using XML input.