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
Problem Reading Fixed width File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In other words, yes. You'll need to enable the Contains Terminators option for those columns. Slide the Columns tab over the the right to see that particular option.
If you didn't have any data fields with newlines in them, then a "wc -l" for your file would return "1".
If you didn't have any data fields with newlines in them, then a "wc -l" for your file would return "1".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Problem Reading Fixed width File
It looks like you have 7000 line terminators only in your input file.
Re: Problem Reading Fixed width File
It looks like you have 7000 line terminators only in your input file.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Problem Reading Fixed width File
It looks like you have only 7000 line terminators (^M) in your input file.
Try removing all line terminators (^M) in your input file and set Line terminator none.
Lakshmi Srinivas
Try removing all line terminators (^M) in your input file and set Line terminator none.
Lakshmi Srinivas
umamahes wrote: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