Error in reading Sequential file

datasis · Post by **datasis** » Tue Dec 08, 2009 6:38 am

Try to read a simple sequential file,Getting Warning message in director

Sequential_File_3,0: Missing record delimiter "\n", saw EOF instead
Sequential_File_3,0: Import warning at record 5

what delimiter should i use in final delimiter, i have used end and also none,but getting the same error meaasge

File structure is like

EMPNO,ENAME,SALARY
1,AAA,3443
2,BBB,4543
3,AAA,2243
4,DDD,2243
5,EEE,5673
6,DDD,7873

chulett · Post by **chulett** » Tue Dec 08, 2009 6:46 am

How many records are in your file?

ray.wurlod · Post by **ray.wurlod** » Tue Dec 08, 2009 1:29 pm

This message usually means that the final record in the file is missing its record delimiter. The reader has found the end-of-file marker.

datasis · Post by **datasis** » Tue Dec 08, 2009 9:58 pm

This file has only 10 records in it

satish.raghavan · Post by **satish.raghavan** » Tue Dec 08, 2009 10:33 pm

Try to declare the final delimiter as none and record length as fixed width and then execute it. even if you declare only the final delimiter as none it may work.

chulett · Post by **chulett** » Tue Dec 08, 2009 10:57 pm

Setting it to 'fixed width' for a csv file makes no sense, unfortunately. And neither does it hitting EOF after reading 5 records when there's allegedly 10. We're missing something here.

bachi · Post by **bachi** » Wed Dec 09, 2009 5:52 am

Try to read the file as varchar then change accordingly as the metadata.u can avoid that warings

Kryt0n · Post by **Kryt0n** » Wed Dec 09, 2009 2:32 pm

Post a hex dump of lines 5 and 6 (to see if there are any hidden characters)