Sequential File problem

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
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Sequential File problem

Post by mydsworld »

How do I handle files with DOS Line termination (CR LF) in Sequential File stage in a Parallel job. The Record delimiter in Format tab has only the following options :

Unix New Line
blank
null

Thanks.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

From the manual:
To implement a DOS newline, use the Record delimiter string property set to "\R\N" or choose Format as -> DOS line terminator from the shortcut menu.
-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 »

Note that there are two separate properties.

Record Delimiter is used when you have one character (or none) to mark the end of a line.

Record Delimiter String is used when you have more than one character to mark the end of a line. Record Delimiter String offers "DOS style" as a preconfigured selectable value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
krisna
Participant
Posts: 77
Joined: Tue Apr 08, 2008 11:33 pm

Post by krisna »

Sequential file properties -> format -> Record level -> Record Delimiter String = DOS Format.

and also

Sequential file properties -> format -> Record level -> Final Delimiter = end
Post Reply