unable to read Xml file

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
krishna81
Premium Member
Premium Member
Posts: 78
Joined: Tue May 16, 2006 8:01 am
Location: USA

unable to read Xml file

Post by krishna81 »

Hi,

i am unable to read the following data through xml input stage.

<?xml version="1.0" encoding="UTF-8"?>
<XML>
<product>
<number>123</number>
<color><blue></color>
<location>A</location>
</product>
</XML>

Here i have issue with <color><blue></color>.

Thanks
Kris
Datastage User
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What issue, exactly? Does everything else parse out, just not that? Is there an error or warning generated? You really haven't given us any information about your job either - for example the XPath Expressions you are using in the XML Input stage, in particular for this element.
-craig

"You can never have too many knives" -- Logan Nine Fingers
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Yes...what is the symptom? If <blue> is truly the value of the element, then it should have been escaped (the carets should not be visible like that in the raw xml)....you should instead see < and >

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
krishna81
Premium Member
Premium Member
Posts: 78
Joined: Tue May 16, 2006 8:01 am
Location: USA

Post by krishna81 »

I am not getting any warnings/errors.But it stop reading from <color><blue></color>.
<blue> is not an element it is data for color element.
Datastage User
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You've got bad XML. As noted, it should look like this:

<color><blue></color>

Ask whomever supplied / generated it to correct the problem.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply