Converting a nullable source to a non-nullable result
Posted: Tue Sep 21, 2010 1:58 am
Hi All,
I have job design as below:
dataset------>cpy----->DB2
in dataset i have two columns,one is order_nbr(decimal(9,0) and nullable value is "no".The other one is order_key(integer(10) and nullable is yes.The job ran successfully but getting warning as "When checking operator: When binding output schema variable "outRec": When binding output interface field "INTERNET_ORDER_NBR" to field "INTERNET_ORDER_NBR": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
Can any one help me out on this?
Thanks & Regards,
Kalpana.
I have job design as below:
dataset------>cpy----->DB2
in dataset i have two columns,one is order_nbr(decimal(9,0) and nullable value is "no".The other one is order_key(integer(10) and nullable is yes.The job ran successfully but getting warning as "When checking operator: When binding output schema variable "outRec": When binding output interface field "INTERNET_ORDER_NBR" to field "INTERNET_ORDER_NBR": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
Can any one help me out on this?
Thanks & Regards,
Kalpana.