Page 1 of 1

Getting warning message in sequential file stage

Posted: Fri Mar 19, 2010 4:59 am
by kaushal.kumar@igate.com
Hi,

I am getting Sequential_File_11,0: Missing record delimiter " ", saw EOF instead " warning message in sequential file stage.I am reading fixed width length file.
Please advice :(

Posted: Fri Mar 19, 2010 5:15 am
by ArndW
This is a very basic error message, it means that your file contents do not match up with your DataStage file definition. Specifically, with a fixed width file, your column widths don't match up. In addition, usually fixed width files don't have record delimiters.

Posted: Fri Mar 19, 2010 5:36 am
by ray.wurlod
It may be that your last line in the file lacks a record delimiter character.

That's why EOF was unexpectedly encountered.

Posted: Fri Mar 19, 2010 6:42 am
by kaushal.kumar@igate.com
ray.wurlod wrote:It may be that your last line in the file lacks a record delimiter character.

That's why EOF was unexpectedly encountered. ...
thanks a lot :)

Posted: Wed Nov 21, 2012 7:25 am
by battaliou
In the Sequential file stage set your Source File to /dev/null and add a Filter with the following:

sort debug.txt

If you need to remove the header then:
sort debug.txt sed '$d'