Converting a nullable source to a non-nullable result

[kalpanam]

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.

[ArndW]

(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.

[chulett]

(note - you have two different question with the same topic, this can lead to confusion)

Note, fixed.