Warning:Missing record delimiter "\n", saw EOF ins

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
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Warning:Missing record delimiter "\n", saw EOF ins

Post by G SHIVARANJANI »

Hi,

I am trying to read a fixed width file .txt

While reading when the file has a new line it do not give the warning
Warning:Missing record delimiter "\n", saw EOF instead

Else when the file has no newline at the end of the records
it gives a ewarning
Missing record delimiter "\n", saw EOF instead

Please do suggest how can i remove this warning.

Thanks
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Do you mean to say, you didnt get the warning when you had the new line character in you file?
Try to delete the last line of the file and check it out.
If you albe to see the file from any Text Editior where you can view the Newline character and spaces and tabs, you might a empty line as last line. Just my guess.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I think it's the other way around - the last line in the file lacks a line terminator. Because the metadata specifies that each line has one, the warning is thrown on the final line.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Post by G SHIVARANJANI »

The data is this way

Case 1

ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
|


Case 2


ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB|


In both the case '|' is just to show you the position of the cursor in the file.

case 1 do not throw this warning where as Case 2 throws warning

Please suggest a solution.

In format i have given just Delimiter = None.
And for record delimiter i did not specify it..








ray.wurlod wrote:I think it's the other way around - the last line in the file lacks a line terminator. Because the metadata specifies that each line has one, the warning is thrown on the final line. ...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Suggestion: use the file format in Case 1.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Suggestion: use the file format in Case 1.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

As described by Ray, the case II, does not have new line character at all, rather EOF is present in it.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply