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.
Sequential file warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your file uses two characters as the line terminator. Either use the Record Delimiter String property set to \r\n or define a fourth Char(1) column (to read the \r) and specify UNIX newline as the Record Delimiter property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.