When I create files in DataStage, and opening them with notepad, all are in one line, they are in unix format.
is there a way to write in dos format? with carriage return and line feed characters?
it can be done in server but not in parallel. or at least i couldnt find the option.
creating sequential file in dos mode
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada
In the Sequential File stage, Format tab, Add "Record Delimiter String" and set it to "DOS Format". It will automatically remove "Record Delimiter = UNIX Newline" if it is present.
The reason it is a "string" instead of just a delimiter is that the DOS end of line has a carriage return and a line feed, as opposed to UNIX which just has a line feed. That's why when you view a DOS file in UNIX you see a visible ^M at the end of the line.
The reason it is a "string" instead of just a delimiter is that the DOS end of line has a carriage return and a line feed, as opposed to UNIX which just has a line feed. That's why when you view a DOS file in UNIX you see a visible ^M at the end of the line.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's just Notepad. Use Word; it can "translate" the UNIX line terminators. Maybe WordPad can too, I've never tried it. I usually use Word (or UltraEdit) because I usually want to see line numbers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.