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.
How to use XML as source in parallel Extender
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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?
Why not you display you error logs here?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>