XML Parse Issue

dssiddu · Post by **dssiddu** » Tue Mar 01, 2011 7:00 pm

Hello all

The below example explains the issue

XML Structure like as below

ns0:Element1
ns1:Element2< Elements3,4,5>
ns1;Element2<Elements3,4,5>

Issues :
1)when we import in Datastage to XML input stage will get ??? for ns1 in the xpaths.
2) when we run it we wont get the values for Elements3,4,5
3) Even if provide the ns1 in the xpath still not giving the values for Elements3,4,5

Could you please light on this ...

Thanks

greggknight · Post by **greggknight** » Tue Mar 01, 2011 8:21 pm

Did you creat a schema?
Did you read the documentation on using the object and how to configure it?
Did you define your repeating element?

dssiddu · Post by **dssiddu** » Wed Mar 02, 2011 6:14 am

Hi Greg

Did you creat a schema?-Yes
Did you read the documentation on using the object and how to configure it?
No idea how to config apart from the xpaths?

Did you define your repeating element? --Yes

greggknight · Post by **greggknight** » Wed Mar 02, 2011 8:48 am

http://publibfp.boulder.ibm.com/epubs/pdf/c1899472.pdf

FranklinE · Post by **FranklinE** » Wed Mar 02, 2011 10:57 am

greggknight wrote:http://publibfp.boulder.ibm.com/epubs/pdf/c1899472.pdf

Gregg, thanks for posting that link. Question for which I'm looking for the briefest answer (I'll do my own detail work): I began using the XML stages under 7.5.2 recently. Is there a highest-level view of changes from that to 8.5? My shop is not likely to get to 8.x very soon, so I'm just looking for a starting point. Thanks.

eostic · Post by **eostic** » Wed Mar 02, 2011 1:40 pm

The XML Stages are fairly consistent from release 6.5, when they were available as an add-on, up until 8.1, with FP1. The behavior, usage, features remain mostly constant, although in 8.0 there were numerous anomalies --- you need at least 8.1 with FP1 to have things fully operational in the 8.x environment.

Those Stages I refer to are the second implementation of xml support in DataStage, and generally referred to as xml pack 2.

They exist "as is" in 8.5 also.....but....

In 8.5 we now ALSO have a new xml stage (lovingly referred to as xmlPack3) --- wholly new approach to working with XML...it's a hierarchical editor packed inside of the new xml Stage with a lot more power...it can handle any size xml, it is much faster, and it manipulates hierarchical data much easier --- which is critical for construction of complex xml documents. It is already taking DataStage in some new directions regarding xml processing.

There is lots of new stuff for all of us to learn. ; )

Ernie

dssiddu · Post by **dssiddu** » Wed Mar 02, 2011 6:19 pm

Hello

Thanks a ton for your info
I am using the Datastage ver 8.1 with fp1 but still my issue not resolved

I have good schema and name space but I tried with name space and without name space also but no luck

/ns0:Element1/ns1:Element2...

Thanks