XMLStage HJoin incompatible keys

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
ymadden@bmi.com
Premium Member
Premium Member
Posts: 21
Joined: Fri Feb 01, 2013 9:13 am

XMLStage HJoin incompatible keys

Post by ymadden@bmi.com »

I'm hoping this is a simple question, I couldn't find anything in the forum, documentation or the almighty Google though...

I'm trying to use the XMLStage to transform some rather complex xml documents. The document has several lists that are related by ID and IDREF typed elements. I can't get past an error saying the ID and IDREF key items are not compatible in my HJoin step. Does the HJoin step in the XMLStage not support joining on items of different types?

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

Post by eostic »

I haven't tried with different types, probably out of habit --- I would just change the datatypes upstream so that they match. No sense wrestling with this inside the Assembly.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
ymadden@bmi.com
Premium Member
Premium Member
Posts: 21
Joined: Fri Feb 01, 2013 9:13 am

Post by ymadden@bmi.com »

Thanks Ernie, this was mostly a learning exercise for myself to get familiar with the Assembly. I was able to move past the error by changing from Strict to Minimal Validation in the Parser step. Somewhere in the documentation I saw a blurb that indicated minimal validation treats all data types as string. Oddly though, I had to remove and add back in the HJoin step before it recognized the changes from the Parser step.
Post Reply