Specifying Delimiter Value on Sequential files

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
PeteM
Premium Member
Premium Member
Posts: 19
Joined: Thu Dec 15, 2011 8:50 am
Location: uk

Specifying Delimiter Value on Sequential files

Post by PeteM »

Is it possible to specify a string delimiter when reading files i.e. ' ~' (space then tilde)?

I can see a string delimiter can be specified when writing to files.
Thanks
PeteM
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That should be on the format tab.
-craig

"You can never have too many knives" -- Logan Nine Fingers
PeteM
Premium Member
Premium Member
Posts: 19
Joined: Thu Dec 15, 2011 8:50 am
Location: uk

Post by PeteM »

My offshore resource is telling me that the delimiter option on the outputs format tab only takes one character?
Thanks
PeteM
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sure, but it should also have the standard "delimiter string" option as well. Sorry, can't check in any way just going by the docs.
-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 »

There are two incompatible options. "Delimiter" is a single character. "Delimiter string" is one or more characters. Only one of these can be selected at any one time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PeteM
Premium Member
Premium Member
Posts: 19
Joined: Thu Dec 15, 2011 8:50 am
Location: uk

Post by PeteM »

Thanks Guys. The offshore resource did not see the other option- delimiter string.

Once he selected the 'delimiter string' option the problem was resolved.
Thanks
PeteM
Post Reply