Hierarchical stage - 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Can't help on the specifics of your issue but with 'IllegalStateException' error messages like that, in your shoes I would be involving your official support provider.
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Only other way to isolate the problem is to gradually remove sections from the Hierarchical stage to see when the error message goes away. That would tell you at least what section caused the error.

But yes - you might want to call customer service on it to get their take on the problem.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Simpler solution --- work on dumping the entire response as a single "chunked" text column (like "myXMLresponse")... send it to a sequential file with NONE for delimiter and for quote character and make sure it looks "clean" (just like you have it up above).

Then pass it into the xmlInput Stage. You will have to map the xpath using the xml importer ---- but afterwards, with your Repetition Element of <R>, you will get a nice set of rows for each of the R's, and then can do usual DS techniques to pivot and get the piped output you are looking for. Don't try to do that pivoting inside of the Hierarchical Stage. Too complex to maintain, even if you can figure it out.

Ernie
Ernie Ostic

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