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.
Converting a nullable source to a non-nullable result
Moderators: chulett, rschirm, roy
Converting a nullable source to a non-nullable result
Kalpana Marupudi
(note - you have two different questions with the same topic, this can lead to confusion)
When you read from a DB2 stage the column attributes come from the database, not from the DB2 stage column settings. Turn on "APT_PRINT_SCHEMAS" to confirm this.
the INTERNET_ORDERN_NBR column in DB2 is nullable.
When you read from a DB2 stage the column attributes come from the database, not from the DB2 stage column settings. Turn on "APT_PRINT_SCHEMAS" to confirm this.
the INTERNET_ORDERN_NBR column in DB2 is nullable.
Last edited by ArndW on Tue Sep 21, 2010 7:41 am, edited 1 time in total.