problem in writing the data to sequential file(txt file)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
problem in writing the data to sequential file(txt file)
Hi All,
When I am checking the text file created in one of our jobs the records are written as below example
Col1 Col2 Col3 111,AAA,Y
222,BBB,Y
333,CCC,N
First line with column names and the records are written in the same line instead of a newline.
What could be the issue?
format used
Delimiter =comma
final delimiter=end
Record Delimiter=UNIX newline
When I am checking the text file created in one of our jobs the records are written as below example
Col1 Col2 Col3 111,AAA,Y
222,BBB,Y
333,CCC,N
First line with column names and the records are written in the same line instead of a newline.
What could be the issue?
format used
Delimiter =comma
final delimiter=end
Record Delimiter=UNIX newline
N.Srinivas
India.
India.
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
the new line character in unix (as you see using vi,cat etc) is different from the one in Windows, and this topic has already been discussed in these forum.
try to cat the file in Unix and since you have used Unix new line as the record delimiter you will find that the records do appear in multiple lines.
try to cat the file in Unix and since you have used Unix new line as the record delimiter you will find that the records do appear in multiple lines.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: