DSXchange

Posted: **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.

Posted: **Tue Sep 21, 2010 4:09 am**

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

Posted: **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.

DSXchange

Handle_null() function in modify stage

Handle_null() function in modify stage