Warning Message

[donlank]

Hello,

Converting nullable source to non-nullable result; fatal runtime error could occur (use modify operator to specify value to which null should be converted)

Does anyone know how to remove this error with the "modify operator"?
What is the "modify operator"?

I looked at the Modify Stage, but in the documentation, there is nothing about nullable conversions.


Thanks,
Kevin

[nkreddy]

You might need to fill in something in the Modify Stage for the nullable source...

For example:

COLUMN:string = NullToZero(COLUMN,0)

Or you can say NullToEmpty....

Refer page 493 in Parallel Developer's Guide

[dswizard]

Hi

You can default the value of that column to some default value incase if it comes as null. It is like NVL in sql. If F1 is the field that you comes as null , you can specify something like

F1 = HANDLE_NULL(F1,999) in modify stage.

Hope this helps

[T42]

Modify Operator (Stage) used to be the primary method for conversion of nullability type. Now you can do it within Transformer Stage. Do an "If IsNull(Field) Then Value Else Value"

Modify Operator use OSH functions, not DataStage functions. So IsNull() will not work. is_null() will work.