DSXchange

The following transform is not putting spaces into the column in DataStage 8.1. It works fine in DS 7.5.2. The code was converted. The column contains null in DS 8.1

IF NullToValue(TO_Transform.PROV_LOC_CD,"999") = "900" THEN NullToValue(TO_Transform.BZET_PRO_ID," ") ELSE Space(10)

Did you search the forum ?
What is the datatype ? Is the column stated nullable ? Try "If Isnull(col) then ' ' else col" instead of NullToValue.

Also move this post to parallel forum for better response.

What is the datatype of the column and what do you mean by 'null' - empty string or a null value?