Page 1 of 1

Sequential File problem

Posted: Mon Nov 17, 2008 10:20 am
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.

Posted: Mon Nov 17, 2008 10:32 am
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.

Posted: Tue Nov 18, 2008 1:09 am
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.

Posted: Wed Nov 19, 2008 11:30 pm
by krisna
Sequential file properties -> format -> Record level -> Record Delimiter String = DOS Format.

and also

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