sequential file warning
Moderators: chulett, rschirm, roy
sequential file warning
I'm reading a sequential file with the following format
col1 char(3)
col2 char(5)
col3 char(8 )
and below are my sample data:
1112222233333333
4445555566666666
The sequential file stage has this definition:
Record Level - final delimiter = none
Field Level - Delimiter = none
Quote = none
This are the warnings I got in the Director log:
Sequential_File_0,0: Import consumed only 16bytes of the record's 17 bytes (no further warnings will be generated from this partition)
Sequential_File_0,0: Import warning at record 0:
Sequential_File_0,0: Missing record delimiter "\n", saw EOF instead
Sequential_File_0,0: Import warning at record 1:
Can someone help me by explaining why I'm getting the warnings? What did I do wrong? Why the first warning complained about the record has 17 bytes when to me it only has 16 (3+5+8= 16).
Thanks in advance.
col1 char(3)
col2 char(5)
col3 char(8 )
and below are my sample data:
1112222233333333
4445555566666666
The sequential file stage has this definition:
Record Level - final delimiter = none
Field Level - Delimiter = none
Quote = none
This are the warnings I got in the Director log:
Sequential_File_0,0: Import consumed only 16bytes of the record's 17 bytes (no further warnings will be generated from this partition)
Sequential_File_0,0: Import warning at record 0:
Sequential_File_0,0: Missing record delimiter "\n", saw EOF instead
Sequential_File_0,0: Import warning at record 1:
Can someone help me by explaining why I'm getting the warnings? What did I do wrong? Why the first warning complained about the record has 17 bytes when to me it only has 16 (3+5+8= 16).
Thanks in advance.
Last edited by Karine on Mon Apr 02, 2007 3:21 pm, edited 1 time in total.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
It depends.
I had replied to a duplicate post here before I came across this one. Realizing that the other post was in the wrong forum, I had deleted my reply on that one and copied the reply over here, without paying attention to the OS.
If it is a unix file then use UNIX newline . If its a dos file copied over to unix in binary, then you can use DOS newline or follow Ray's instructions in that other post I referenced here in.
I had replied to a duplicate post here before I came across this one. Realizing that the other post was in the wrong forum, I had deleted my reply on that one and copied the reply over here, without paying attention to the OS.
If it is a unix file then use UNIX newline . If its a dos file copied over to unix in binary, then you can use DOS newline or follow Ray's instructions in that other post I referenced here in.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Sorry for the confusion and the wrong post. My OS is windows.
I've following Ray's suggestion :
Record Level - Final delimiter = none
Record delimiter string = \r\n (dos format)
and still the warning said
Sequential_File_0,0: Missing Delimiter "\r\n", saw EOF instead
Sequential_File_0,0: Import warning at record 1
What can be the explanation? Please help me to understand.
I've following Ray's suggestion :
Record Level - Final delimiter = none
Record delimiter string = \r\n (dos format)
and still the warning said
Sequential_File_0,0: Missing Delimiter "\r\n", saw EOF instead
Sequential_File_0,0: Import warning at record 1
What can be the explanation? Please help me to understand.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Code: Select all
Record Level - Final delimiter = \n (Dos Format)
Record delimiter string = none
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)