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
NullHandling
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.