sequential file warning

Karine · Post by **Karine** » Mon Apr 02, 2007 6:46 am

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.

DSguru2B · Post by **DSguru2B** » Mon Apr 02, 2007 7:18 am

Specify Record Length as "Fixed" and see if that helps. Also try specifying Record Delmiter as "DOS newline."

samsuf2002 · Post by **samsuf2002** » Mon Apr 02, 2007 10:51 am

DSguru2B wrote:Specify Record Length as "Fixed" and see if that helps. Also try specifying Record Delmiter as "DOS newline."

DSGuru2B- Can we use "DOS newline" when we are using UNIX?

DSguru2B · Post by **DSguru2B** » Mon Apr 02, 2007 10:56 am

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.

Karine · Post by **Karine** » Mon Apr 02, 2007 3:31 pm

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.

novneet · Post by **novneet** » Mon Apr 02, 2007 3:45 pm

Delete the property "QUOTE" completely, and then try it out.

Karine · Post by **Karine** » Mon Apr 02, 2007 5:20 pm

I have remove "Quote" property but still got the same warning.
Any other suggestions? This is really bugging me.

DSguru2B · Post by **DSguru2B** » Mon Apr 02, 2007 6:05 pm

Delete the Record Delimiter and keep the Record Delimiter String. See if that helps. Also, view the file with a hex editor and see what do you have at the end, exactly.

us1aslam1us · Post by **us1aslam1us** » Mon Apr 02, 2007 6:49 pm

Code: Select all

  Record Level - Final delimiter = \n (Dos Format)
  Record delimiter string = none

That should be enough unless you have any other thing as a record delimiter. As suggested by DsGuru read your file in hex editor and check what exactly is your record delimiter.