SunsContactFile...sequential_File_10.DSLink14:read_fixedwidth() - row 1 ,column Street_Address,
column unexpectedly ended by EOR
Could some body explain , how the terminators field should be for a fixed format file.
Thank you all,
Greatly appreciated for ur help.
Error while viewing the data EOR
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Kollurianu,
the message says everything you need to know. DataStage is reading merrily along the parts of a fixed-width record. It reaches the actual file end-of-record before it's fixed-width column declaration
the message says everything you need to know. DataStage is reading merrily along the parts of a fixed-width record. It reaches the actual file end-of-record before it's fixed-width column declaration
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Hi Annapurna,
I had a similar problem and again the great man Arnd helped me out of it.
My understanding of your problem is that there is a line terminator in your last or intermediate records (probably the last).
What you can do:
1. In the Output Stage, go to the columns tab, and go to "Contains Terminators" and select "Yes" in the drop down. And when you do this, also do 2.
2. Go to the "Incomplete Columns" and select "Retain".
3. Save the job and Run.
Let me know if it works.
Naveen.[/quote]
I had a similar problem and again the great man Arnd helped me out of it.
My understanding of your problem is that there is a line terminator in your last or intermediate records (probably the last).
What you can do:
1. In the Output Stage, go to the columns tab, and go to "Contains Terminators" and select "Yes" in the drop down. And when you do this, also do 2.
2. Go to the "Incomplete Columns" and select "Retain".
3. Save the job and Run.
Let me know if it works.
Naveen.[/quote]
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Kollurianu,
if you don't tell the sequential file stage about any terminators then it will be off by one byte... the fixed-width format allows no leeway on errors What Naveen says is also true, this option should only be used if you have a file where the trailing spaces have been chopped off (some FTPs tend to do this) but the file remains essentially a fixed-width one.
if you don't tell the sequential file stage about any terminators then it will be off by one byte... the fixed-width format allows no leeway on errors What Naveen says is also true, this option should only be used if you have a file where the trailing spaces have been chopped off (some FTPs tend to do this) but the file remains essentially a fixed-width one.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>