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
times29
Premium Member
Posts: 202 Joined: Mon Sep 22, 2008 3:47 pm
Post
by times29 » Thu Apr 12, 2012 12:31 pm
Hi,
i was getting column null error so i did NullToValue(to_transf.COUNTRY_CODE,'WW') and now i am getting
Transform,0: Fatal Error: Null value on the accessor interfacing to field "COUNTRY_CODE"
Thanks
Nsg
Premium Member
Posts: 37 Joined: Thu Jan 26, 2006 1:21 pm
Post
by Nsg » Thu Apr 12, 2012 3:37 pm
Is "COUNTRY_CODE" a result from a lookup in earlier stages ?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 12, 2012 4:04 pm
Are you using COUNTRY_CODE in a stage variable or constraint expression?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
times29
Premium Member
Posts: 202 Joined: Mon Sep 22, 2008 3:47 pm
Post
by times29 » Fri Apr 13, 2012 8:28 am
Is "COUNTRY_CODE" a result from a lookup in earlier stages ?
No its mapped from db2 table to transformer
Are you using COUNTRY_CODE in a stage variable or constraint expression?
stage variable
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Fri Apr 13, 2012 9:05 pm
It depends on whatever version you're using and its options.
Read through this topic and the tech notes about legacy null processing options and stage variables:
viewtopic.php?t=145218
Choose a job you love, and you will never have to work a day in your life. - Confucius
kandyshandy
Participant
Posts: 597 Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore
Post
by kandyshandy » Sun Apr 15, 2012 8:44 pm
Also, check if COUNTRY_CODE is used in derivation of the some other output column. I mean you may have used COUNTRY_CODE directly in some other derivation.
Kandy
_________________
Try and Try again…You will succeed atlast!!