Null value in Sequential file stage..

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
verify
Premium Member
Premium Member
Posts: 99
Joined: Sun Mar 30, 2008 8:35 am

Null value in Sequential file stage..

Post by verify »

For one of my field in the target i'm doing Null handling.
I used this function for handling null "NullToValue()".
For e.g:
OP.Col1 --> NullToValue(IP.Col1,' ')

And this field i'm mapping to sequential file stage and a dataset stage.

The job ran successfully but when i'm viewing the data for this field the output in Sequential file stage it shows as "NULL" but in dataset as " ".

But when i opened my sequential file in unix box the output is " ".
Could anyone please tell me why "NULL" is appearing?
Is there any possibility to change the output..

Please help me out...
RK Raju
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Null value in Sequential file stage..

Post by betterthanever »

don't go with view data option in the seq file stage to check what is written to the file

what you see when you open the file on UNIX box, is what you have in the file...

or try this

when writing to seq file...set the property under field defaults -->null field value --> ""
and see
Post Reply