DSXchange

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

How many records are in your file?

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.

This file has only 10 records in it

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.

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.

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

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