Page 1 of 1

How to use XML as source in parallel Extender

Posted: Thu May 24, 2007 12:14 am
by shaonli
While developing a job using XML we use folder stage before XML input stage in Datastage Server job.If I want to develope the same job in Parallel extender how to do it as there is no folder stag in parallel extender.

Please suggest.

Posted: Thu May 24, 2007 1:43 am
by ray.wurlod
What precisely do you want to accomplish? The parallel Sequential File stage can read multiple files, whether using multiple File properties or using a file pattern (wildcard). But then what?

Posted: Thu May 24, 2007 3:35 am
by shaonli
I tried to use Sequential File stage to read multiple files.
I have set
Source->Read Method->File patternS
Source->File Pattern->filepath/*.xml

I have selected one single column named 'Record' only to store the XML.

In the next stage XML Input Stage in the input tab I have selected Record as XML source Column.

But it is not working.

Please suggest.

Posted: Thu May 24, 2007 4:07 am
by JoshGeorge
You can definitely read multiple files using wildcard. Your column mapping names need not be the same for all other columns other than reject link. You just have to map to corresponding column name with right derivation. Have you specified a repetition element?

Why not you display you error logs here?