How to extract the XML Files to DS Eterprise editionPX 7.5x

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
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

How to extract the XML Files to DS Eterprise editionPX 7.5x

Post by deesh »

Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Not sure what your problem/error is? Are you looking for how to read XML in EE? I find the easiest way is to use the External Source stage...there's a thread on this from last week....

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Re: How to extract the XML Files to DS Eterprise editionPX 7

Post by sravanthi »

deesh wrote:Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion
Use server job.Folder stage-->xml input file-->target.
sravanthi
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

sravanthi,

Folder stage doesn't exists in DS EE jobs. It is limited only to the server jobs.

deesh,
U have to use the

Code: Select all

 XMLInput-->XML Transformer-->XML output
If you want to read multiple files you can use the sequencial file stage with 'Read Method= File Pattern' and 'Record Type=implicit' in it.
Infact, i am also new to it and rightnow working on this stuff. :)
You have lot of stuff discussed on it mostly answered by expert: Ernie :wink:
Thanks and Regards!!
dspxlearn
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Post by sravanthi »

dspxlearn ,

I have not used px jobs for reading xml.I was unable to find where can we mention input file name in xml input or xml transformer stages.Just curious to know..
sravanthi
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

It comes from the previous Stage...either content or URL.
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply