Transform logic not working in DS8.1 working in DS 7.5.2

colhogan · Post by **colhogan** » Sat Mar 06, 2010 5:09 pm

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)

samsuf2002 · Post by **samsuf2002** » Sun Mar 07, 2010 12:03 am

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.

ArndW · Post by **ArndW** » Mon Mar 08, 2010 5:07 am

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