write "" as NULL value into sequential file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

write "" as NULL value into sequential file

Post by abyss »

Hi all
I am sure someone asked it before but i couldn't find it on this form.
my question is simple: how to print "" (two double quotations) into sequential file?

for example:
the current output like: "a","b",,,"e"
i want change the output to: "a","b","","","e"

thanks in advance
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well... it doesn't really seem to be something that's needed as those bare commas should process just fine. However, assuming the value is NULL in your source (from your subject) have you tried using the NullToEmpty() function?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Server job, Craig.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well aware of that and know that's the name of a Parallel function... but I recalled using a function much like that back in my Server days (hence the advice) but perhaps it was one we built? :? Ah well, just a pretty brain dead if-then-else.

Bottom line, wondering if a simple test for NULL and replacing it with an empty string would get the desired end result...
-craig

"You can never have too many knives" -- Logan Nine Fingers
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Post by abyss »

thanks guys
I found the solution to work around in this job, I put the the server job to the end, so the out put file don't need to be read by any other job.
I will leave it like that for now until next time...

Cheers
Howard
Post Reply