Null values in Dataset

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
Nripendra Chand
Premium Member
Premium Member
Posts: 196
Joined: Tue Nov 23, 2004 11:50 pm
Location: Sydney (Australia)

Null values in Dataset

Post by Nripendra Chand »

Hi,

i can define null values in sequential files through its attribute editor. But i'm not able to do it for Dataset. By default Dataset is showing 0 for null values. How can i change these to some other value.

-Nripendra
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi Nripendra,

The advantage of dataset is that it can store persistent data. It stores a NULL only as NULL and not 0.

If you want to handle null and provide some other value in the dataset other than 0 then use Transformer(NullToValue) or a Modify stage(handle_null).

HTH
Rich
Nripendra Chand
Premium Member
Premium Member
Posts: 196
Joined: Tue Nov 23, 2004 11:50 pm
Location: Sydney (Australia)

Post by Nripendra Chand »

thanks Richdhan.
Currently i'm using modify stage for null replacement.

-Nripendra
Post Reply