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
Bicchu
Participant
Posts: 26 Joined: Sun Oct 03, 2010 10:49 pm
Location: India
Post
by Bicchu » Fri May 06, 2011 8:28 am
Hi,
I am newbee in datastage. I am trying to explore Modify stage. I am going through the Parallel Job Developers Guide. There a converstion function "NullToValue" is mentioned for null handling. But when I am trying to use it in my job it is throwing error.
Error Message:
"main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue"
Can anybody throw some light on this?
Thanks,
Pratik.
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Fri May 06, 2011 8:50 am
"NullToValue" is used in transformers and not in modify stage..
In modify stage it should be something like..
PHONE = handle_null (PHONE,-128)
See Parallel Job Developers Guide under Modify stage.
Bicchu
Participant
Posts: 26 Joined: Sun Oct 03, 2010 10:49 pm
Location: India
Post
by Bicchu » Fri May 06, 2011 9:36 am
Ok Thanks..but actually in parallel job developers guide it is given NullToValue.
Thanks,
Pratik.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri May 06, 2011 10:10 am
Unfortunately, the Guide is known to have misinformation in it regarding the Modify stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Nagaraj
Premium Member
Posts: 383 Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore
Post
by Nagaraj » Fri May 06, 2011 12:13 pm