nulltovalue

times29 · 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 · Post by **Nsg** » Thu Apr 12, 2012 3:37 pm

Is "COUNTRY_CODE" a result from a lookup in earlier stages ?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 12, 2012 4:04 pm

Are you using COUNTRY_CODE in a stage variable or constraint expression?

times29 · 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 · 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

kandyshandy · 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.

DSXchange

nulltovalue

nulltovalue

Re: nulltovalue