XML parsing

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
Gopalraja
Participant
Posts: 18
Joined: Wed Jun 18, 2008 3:51 am
Location: Chennai

XML parsing

Post by Gopalraja »

Hi,
I'm using xml file as a source. By using External source stage I'm getting the data from xml file.

I'm getting the xml data in a single record format and extract the original data and write the same to Sequential file from this single record.

Job got success and single record was passed to the xml input stage but output of the xml input stage written 0 record to the Sequential file.

How to write the namespace declaration in the xml input stage - General tab and output tab. If I'm loading the namespace declaration from Table definition it just write the XSD schema like this below..

xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"

It would not write the xsd schema element names and types for all the colums.

Design Flow:
---------------

Exteranal Source ---> XML Input ----> Sequential file

Let me know do you have any idea regarding this...

Thanks in Advance
Aswice
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

If you are getting 0 rows, it is likely because there are problems in the xpath..... check the Description property of each column on the output link.....check the EXACT spelling, and the hierarchy that gets you to each element and attribute.....

Ernie
Ernie Ostic

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