Problem Reading Fixed width File
Posted: Tue Jun 26, 2007 12:05 pm
Hi,
I am getting the following warning when i tried to reqad fixed width file with ASCII characters
Capitationtest..Sequential_File_0.DSLink2: read_fixedwidth() - row 66, column WK_MEMBER_NUMBER, column unexpectedly ended by EOR
In the sequential stage if i use line termination none then only i am able to read this file.when i do wc -l on unix it is showing 7000 records but it has 1 million records actually.so what is the problem.IF i use none as line termination i am able to view the data with out any warning.When i run the job with this option i am getting the following error.
Capitationtest..Sequential_File_0.DSLink2: read_fixedwidth() - row 607678, column WK_CARRIER, column unexpectedly ended by EOR
I am getting the following warning when i tried to reqad fixed width file with ASCII characters
Capitationtest..Sequential_File_0.DSLink2: read_fixedwidth() - row 66, column WK_MEMBER_NUMBER, column unexpectedly ended by EOR
In the sequential stage if i use line termination none then only i am able to read this file.when i do wc -l on unix it is showing 7000 records but it has 1 million records actually.so what is the problem.IF i use none as line termination i am able to view the data with out any warning.When i run the job with this option i am getting the following error.
Capitationtest..Sequential_File_0.DSLink2: read_fixedwidth() - row 607678, column WK_CARRIER, column unexpectedly ended by EOR