DSXchange

Hi

I have a sequentialFixedwidth file from which i am extracting a field on which i want to do nullhandling. I am using a function

IF IsNull(In.Column[2,20]) Then NullToValue(In.Column[2,20], " ") Else In.Column[2,20]

Its throwing compilation error. Does datastage recognizes null values out of file.If so how to handle it.

Appreciate your help

You have to tell DataStage what value in the file (in each field, if the fields are of different widths) represent null. This is typically achieved through the Null Field Value property.

Search the forum, consult on-line help, or read the Parallel Job Developer's Guide to learn how to set this property for the Sequential File stage.