XML DATA from hierarchy 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
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

XML DATA from hierarchy stage

Post by sainath »

HI

When data is null in my xml file I am getting following weird data www.w3.org/2001/....... data

XSD : <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

how to avoid this .

</AssigneesDetails>
ASSIGNEE_TYPE_CODE [xmlns:xsi="http:/XMLSchema-instance" xsi:nil="true"/>
Moderator : I already paid for premium membership and send email but still my profile not updated
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

<puff of smoke> Moderator here! Two points:

1) There is a specific forum for that particular account issue.

2) We're more like Janitors that clean up posts. Account issues need to be addressed with the site owner and there are stickied posts at the top of the major forums that detail this. (the site owner bit, not so much the janitorial bit) :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
sainath
Premium Member
Premium Member
Posts: 138
Joined: Fri Nov 19, 2004 3:57 pm

Post by sainath »

Hi

Please share your feedback on above issue

thks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If someone had any to share, they would. Patience.
-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 »

Using xsi:nil is the "deeply specific" way to declare that a particular xml element is a "null" value. One of the reasons it was put into the standard is that there is no real way to tell if <element></element> means "blank"?...or does it mean NULL?

The Hierarchical Stage is heavily controlled by the xml schema definition (xsd)....so....it is able to do the "full" nullability specification.

Consequently...

1. xsi nill means "null". The consumer of your xml should at this time be perfectly capable of handing this standard method of specifying null.

2. I haven't tested this in a long time, but as I recall, the composer step will not put in "nil" unless you "validate" in that Step. Shut off validation and that may make it go away.

3. A lot of sites want "no element at all".........there is an option of whether you want to render null columns as elements.

Ernie
Ernie Ostic

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