problem in writing the data to sequential file(txt file)

[srinivas.nettalam]

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

[chulett]

Where are you looking at the file, on Windows?

[srinivas.nettalam]

Where are you looking at the file, on Windows? ...

Yes

[GJ_Stage]

Hi ,

Can you explain what is the flow (i .e what are the stages are used) to create this seq file.

[srinivas.nettalam]

Hi ,

Can you explain what is the flow (i .e what are the stages are used) to create this seq file.

Got the solution...record delimiter string =DOS prompt has to be selected instead of record delimiter =unix newline

[zulfi123786]

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.

[chulett]

Where are you looking at the file, on Windows?

Yes

Yah, that was a hint.

[ray.wurlod]

Use Wordpad rather than Notepad. Wordpad seems to handle both kinds of line terminator gracefully.