DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
abyss



Group memberships:
Premium Members

Joined: 22 May 2014
Posts: 158

Points: 1655

Post Posted: Thu Oct 05, 2017 4:49 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42268
Location: Denver, CO
Points: 217033

Post Posted: Thu Oct 05, 2017 6:46 am Reply with quote    Back to top    

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

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54069
Location: Sydney, Australia
Points: 293272

Post Posted: Thu Oct 05, 2017 11:11 pm Reply with quote    Back to top    

Server job, Craig.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42268
Location: Denver, CO
Points: 217033

Post Posted: Fri Oct 06, 2017 6:52 am Reply with quote    Back to top    

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? Confused 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

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
abyss



Group memberships:
Premium Members

Joined: 22 May 2014
Posts: 158

Points: 1655

Post Posted: Sat Oct 07, 2017 2:29 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours