DSXchange

HI Gm,
V 8.1
i am joing 2 db2 stages by using join stage.

but the problem is from left side key is nullable is no and right side key nullable is yes now i am getting the warning and fatal eror

Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID" to field "PARR_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted


i made changes from right side db2 nullable is no and i tried tu put the modify stage and the specification is PARR_ID = HANDLE_NULL (PARR_ID, "NULL")



i have changed in join output is nullable yes but still i am getting the error
fatal;
Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID" to field "PARR_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted


help me on this regard

A key Column is "Nullable" in DB2 Table.

You should do as suggested and use a modify stage or a transform to convert both source columns to the same nullability in order to avoid this problem.

raju4u wrote:HI Gm,
V 8.1
i am joing 2 db2 stages by using join stage.

but the problem is from left side key is nullable is no and right side key nullable is yes now i am getting the warning and fatal eror

Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID" to field "PARR_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted


i made changes from right side db2 nullable is no and i tried tu put the modify stage and the specification is PARR_ID = HANDLE_NULL (PARR_ID, "NULL")



i have changed in join output is nullable yes but still i am getting the error
fatal;
Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID" to field "PARR_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted


help me on this regard

If your join fails it puts a null,what is the next stage to the join you have make that as nullbale yes.It should go through.