Getting warning message in sequential file stage

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
kaushal.kumar@igate.com
Participant
Posts: 77
Joined: Tue Apr 14, 2009 4:03 am

Getting warning message in sequential file stage

Post 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 :(
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kaushal.kumar@igate.com
Participant
Posts: 77
Joined: Tue Apr 14, 2009 4:03 am

Post 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 :)
battaliou
Participant
Posts: 155
Joined: Mon Feb 24, 2003 7:28 am
Location: London
Contact:

Post 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'
Last edited by battaliou on Wed Nov 21, 2012 7:42 am, edited 2 times in total.
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.
Post Reply