Page 1 of 1
nulltovalue
Posted: Thu Apr 12, 2012 12:31 pm
by times29
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
Re: nulltovalue
Posted: Thu Apr 12, 2012 3:37 pm
by Nsg
Is "COUNTRY_CODE" a result from a lookup in earlier stages ?
Posted: Thu Apr 12, 2012 4:04 pm
by ray.wurlod
Are you using COUNTRY_CODE in a stage variable or constraint expression?
Posted: Fri Apr 13, 2012 8:28 am
by times29
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
Posted: Fri Apr 13, 2012 9:05 pm
by qt_ky
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
Posted: Sun Apr 15, 2012 8:44 pm
by kandyshandy
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.