xml document importing 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
dj
Participant
Posts: 78
Joined: Thu Aug 24, 2006 5:03 am
Location: india

xml document importing in datastage

Post by dj »

Hi

I have been trying to import an xml doc in datastage . i have used

folder stage--> Xml input--> trnasformer--> seq.o/p.

I have exported a job in Xml doc & trying to give as i/p to xml i/p.

The pbm is in Xml input stage , i have given the filename &record in i/p.
I want to get some of my job details as o/p from xml i/p stage.But how do it maps record to the metadata i have loaded..

Could anyone can explain me indetail..

Thanx
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Re: xml document importing in datastage

Post by uegodawa »

First use the DataStage Manager to Load the meta data.
Manager -> Import - > Table def - > XML TAble DEf
Then Open your XML . File -> Open
Then click on all text nodes which you want and save the meta data.
Now goback to your job, open XML Input stage, then output tab , columns, Load.
Then Load the meta data which you saved earlier.
- U
NBALA
Participant
Posts: 48
Joined: Tue Jul 11, 2006 11:52 am
Location: IL, USA

Re: xml document importing in datastage

Post by NBALA »

Guys !

This is a duplicate post. Please do not answer here.

Use the following post to answer.

viewtopic.php?t=103103

-NB
Post Reply