Lookup binding error

ketanshah123 · Post by **ketanshah123** » Thu Jul 17, 2008 8:12 am

Hi
In my parallel job while doing lookup between a dataset and some db2 tabe getting following error

lkp,0: When binding input interface field "XYZ" to field "XYZ": 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

How to remove this error ? from where this error is coming i.e. from input dataset or referenced lookup db2 tables.?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 17, 2008 3:13 pm

Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output, because it will be null in the case that the lookup fails.

ketanshah123 · Post by **ketanshah123** » Thu Jul 17, 2008 10:59 pm

ray.wurlod wrote:Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output ...

thks