Hierarchical stage and null values

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
midmaxds
Premium Member
Premium Member
Posts: 71
Joined: Mon Oct 26, 2015 11:44 am

Post by midmaxds »

Hi,
Any suggestions, please...
Midhun
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Hard to say...some things to test/try --- try turning on validation, make sure that the column is nullable, and that its value is truly null.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
midmaxds
Premium Member
Premium Member
Posts: 71
Joined: Mon Oct 26, 2015 11:44 am

Post by midmaxds »

Thanks, Ernie.
It helped. The value we had earlier was not actually NULL, which caused the issue.
Midhun
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Kinda thought that might be the issue as it had bit me in the past but I always wait for Ernie to chime in first before exposing my XML ignorance. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply