Repeating Elements In Xml Output stage

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
Aquilis
Participant
Posts: 204
Joined: Thu Apr 05, 2007 4:54 am
Location: Bangalore
Contact:

Repeating Elements In Xml Output stage

Post by Aquilis »

all,

Is Values treated as Repeating Elements in XML Output stage wont allow Null values or these always should be Unique values.

I have mentioned two Columns as Repeating elements In Xml Output stage and I am assigning values for the same columns from the functions
DSGetJobInfo(hJob1,DSJ.JOBELAPSED) and DSGetLinkInfo (hJob1, "StageName", "LinkName", DSJ.LINKROWCOUNT).

Is it possible that ,these two functions return Null values ?
Aquilis
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

You'll have to test those functions separately, using isNull functions, etc. to determine their behavior more closely. I've used them, but haven't examined them for every possible return. That should be easy to evaluate by sending the output to a file, peek, etc.

More importantly, on your XML, what is the symptom, or what would you prefer to have XMLOutput do? There are a lot of possibilities, I suppose, depending on your application. You could want an entirely missing element if a value is null, an explicit xsi:nil specification if a value is null, or possibly just have an empty element....

Ernie
Ernie Ostic

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