Share container Exporting nullable field error from Sequ fi

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, and it has nothing to do with using a shared container. It's an error that was not picked up in 8.0 (it IS picked up in 8.7). You need to check that you are sending a nullable field into a Sequential File stage but have not provided a NullFieldValue property to tell that stage how you wish null to be represented in the file. Check not just field_1 but every nullable field.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

Thanks Ray.

Sorry I am not able to understand this statement "it IS picked up in 8.7"

Are you suggesting to change the schema file following way?

name:nullable varchar[1] {default=0, null_field=' '};


Thanks
Man
Post Reply