Handle_null() function in modify stage

kalpanam · Post by **kalpanam** » Tue Sep 21, 2010 4:07 am

Hi All,

I'm having input column order_nbr(decimal9,0) nullable but while loading this to target i'm handling null values by using modify stage function as Handle_Null(order_nbr,"").But is giving error message as "Bad literal for type decimal: ."

Please let me know what is wrong in the above?

Thanks & Regards,
Kalpana.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 21, 2010 4:09 am

Space or blank is not a decimal value. Use a number

kalpanam · Post by **kalpanam** » Tue Sep 21, 2010 4:13 am

Sainath.Srinivasan wrote:Space or blank is not a decimal value. Use a number

Yes,now i used Handle_Null(order_nbr,0) and it is working fine.

Thanks for your timely response.

Regards,
Kalpana.