XML-Input

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

XML-Input

Post by bala_135 »

Hi,

I have worked with server Edition and extracted data from XML inputs.
There was a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL.

How can do the same in parallel jobs.From where i can pass the contents.
I have tried this logic

Row gen---->transformer(passing the URL) ----->XML input--->output.

But the URL which i am passing either as a string or through the job parameter both not working.Any inputs will be most appreciated.

Regards,
Bala
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: XML-Input

Post by sud »

bala_135 wrote:Hi,

... a stage called folder stage which takes two columns in the second i will the contents.in the input of the XML input stage i need to mention abt the contents either as a columns from folder stage or URL.
I really got confused, may be you can try to rephrase.

Are you asking for a way to pass the surce URL to the XML Input Stage ? For that you need to mention Column Content as URL and select the column containing that input. This you can do in the XML Input stage's Inout tab.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Post by bala_135 »

Hi Sud,

Thanks for the reply.Exactly what you have mentioned is right.I am asking a way to pass the source URL to the XML Input Stage.

Example:-I am the XML content in location say D:\customer.xml.
Do you mean to say if i pass this location as the URL in the input tab of the xml stage it will work.If thats is case how do i pass it in paralle jobs.


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

Post by chulett »

Unless the XML stages are different in PX, there's no way to supply anything like a filename or URL directly in the Input tab. You need to pass it in just like you've been doing in a specific field.

However, the Folder stage in Server jobs doesn't provide any magical functionality other than reading wildcarded filenames from a directory. I've used a Transformer to provide a single URL to the XML Input stage via job parameters and it works just fine in Server, so I'd imagine you should be able to do the exact same thing here.

You might want to elaborate on the 'not working' part of your first post where you said you tried that already.
-craig

"You can never have too many knives" -- Logan Nine Fingers
anntaylor
Participant
Posts: 24
Joined: Tue May 10, 2005 5:17 pm

Post by anntaylor »

Yes. Please be more specific about the "not working" I have used the row generator to pass the file name, but not a URL - though it should work similarly.
Post Reply