CSV support in parallel jobs

Do you have features you'd like to see in future releases of DataStage, MetaStage, Parameter Manager, Version Control or one of the other tools represented on this forum? Post your ideas here!

Moderators: chulett, rschirm

Post Reply
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am

CSV support in parallel jobs

Post by PhilHibbs »

Parallel job Sequential File stage can't read or write CSV data. Specifically I mean the convention of doubling up the quote character if it occurs in the data, so this string:

Code: Select all

A rusty 6" nail
would be written out, just like a server job or Microsoft Excel would, as this:

Code: Select all

"A rusty 6"" nail"
Currently, it would be written out by a parallel job like this:

Code: Select all

"A rusty 6" nail"
and neither a server nor parallel job can read this back in again.
Phil Hibbs | Capgemini
Technical Consultant
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am

Post by ArndW »

That is a known issue, and there is a current thread on the same topic.
<a href=http://www.worldcommunitygrid.org/team/viewTeamInfo.do?teamId=TZ9H4CGVP1 target="WCGWin">
Image</a>
ray.wurlod
Participant
Posts: 54582
Joined: Wed Oct 23, 2002 10:52 pm

Post by ray.wurlod »

's right. It's Phil's thread. Obviously he's firing at the vendor with all available ammunition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am

Post by ArndW »

Lol - I should have paid more attention :) I am fairly certain that I put this one in as eCase a couple of years back.
<a href=http://www.worldcommunitygrid.org/team/viewTeamInfo.do?teamId=TZ9H4CGVP1 target="WCGWin">
Image</a>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm

Post by chulett »

Yah... still trying to nail them with that rusty six inch nail, I see. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSRajesh
Premium Member
Premium Member
Posts: 297
Joined: Mon Feb 05, 2007 10:37 pm

Post by DSRajesh »

Its still goes with the same issue either in server or parallel
RD
Post Reply