NULL record dropped issue for decimal to varchar col

[HemaV]

My reference ora stage contains a column salarythousands with decimal datatype

Im performing left outer join of above reference ora stage with my source ora stage and passing field value to transformer.

in transformer im doing calculation as:
stagevariable1 with datatype decimal 11,

stagevariable1 = If IsNull(lk.salarythousands) Or Trim(lk.salarythousands) = "" Then 0
Else ((lk.salarythousands * 1000) / 12)

then passing to target column with varchar datatype as DecimaltoString(stagevariable1)

but still im getting the below error:
Trans_Land,3: Field 'salarythousands' from input dataset '0' is NULL. Record dropped.

Please let me know how to resolve this issue.

Thanks,

[jerome_rajan]

Is it possible that you are using the column "salarythousands" to derive some other column without handling nulls than the one mentioned?

[HemaV]

salarythousands is the original column im using till transformer and then doing calculations.

Problem is salarythousands is decimal datatype and im loading into varchar datatype column in transformer.

Also its using multinode configuration.

Thanks,

[jerome_rajan]

I doubt that the conversion is causing the issue. Please check if any of your other target columns are using the column - "salarythousands". If yes, are any functions applied on it ?

[BI-RMA]

Which version of DataStage are you working with?

In 8.5 and higher this should work when Legacy-Null-handling is switched off on the transformer properties.

In versions prior to 8.5 it was not allowed to pass NULL-values to Transformer-functions as input. In case this happened on any column or stage-variable the complete record was dropped.

And then: why do you use a string-function on a column with decimal-datatype in the first place:

Use
stagevariable1 = If NullToZero(lk.salarythousands) = 0 Then 0
Else ((lk.salarythousands * 1000) / 12)

[jerome_rajan]

In 8.5 and higher this should work when Legacy-Null-handling is switched off on the transformer properties.

In versions prior to 8.5 it was not allowed to pass NULL-values to Transformer-functions as input.

My new learning for the day. Don't know how I missed it this long!

[HemaV]

After using NullToZero function i'm not getting the warnings.

Thanks,