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
Getting warning message in sequential file stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 77
- Joined: Tue Apr 14, 2009 4:03 am
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 77
- Joined: Tue Apr 14, 2009 4:03 am
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'
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.