Null values to Dataset and Sequential File

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
siva7143
Participant
Posts: 35
Joined: Wed Aug 09, 2006 12:20 am

Null values to Dataset and Sequential File

Post by siva7143 »

Hi Guys,

Can we pass empty values to dataset & sequential file ?

Can we pass NULL values to dataset & sequential file ?

If so then please let me know how we can read that values in dataset and sequential file.

Regards,
Siva Kumar :?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Data Sets, yes to NULL values and yes to empty value only if the data type is VarChar.

For sequential files and File Sets you need to specify how NULL is to be represented, typically through the Null Field Value property. Empty value can only be written to VarChar 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.
Post Reply