Converting a nullable source to a non-nullable result;

[Marley777]

Hi, thanks for reading.

What is this error telling me. I'm getting this error on fields where nullable is set to 'no'. Fields are set not nullable throughout the job. The fields are comming from source db2 tables.


"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. [api/interface_rep.C:963]"

Thanks for your help.

[kris007]

It is telling you to handle NULL values that might come from the source. Because you are mapping a nullable field from the source table to a not nullable field on target there is every possibility that you might get NULL values from source. You need to define a default value for NULL's that are coming from source.

[Marley777]

but the fields are set to 'nullable = no' throught the job. This is not a nullable filed, so why do we get the message? Thanks for your help.

[anbu]

Check how the fields are defined in the table.