unable to view the records
Moderators: chulett, rschirm, roy
unable to view the records
Hi all,
when I am trying to view the data from my source flat file I am getting the error like "last column",column unexpectedly ended by EOR.
I checked my datafile field length and the record layout defined in the stage both counts are same.
I mean there is no problem with the datafile and the metadata defined
both lengths are also same
Suggestion required please
Thanks in advance
when I am trying to view the data from my source flat file I am getting the error like "last column",column unexpectedly ended by EOR.
I checked my datafile field length and the record layout defined in the stage both counts are same.
I mean there is no problem with the datafile and the metadata defined
both lengths are also same
Suggestion required please
Thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you getting this message at row 0 or 1, or at a later row? If the former, check that the first line is not column names. If the later, check that row, ensuring that none of the columns contains a line termination character (Char(10)).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: unable to view the records
If that was true you wouldn't be seeing this message.rafidwh wrote:I mean there is no problem with the datafile and the metadata defined both lengths are also same
![Wink :wink:](./images/smilies/icon_wink.gif)
At least one of your records is 'short' and runs out of data before you run out metadata so to speak. Since you are dealing with a fixed width file, ensure you've put the correct column sizes in the 'Display' column as that is what drives the reading of the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
How exactly did you get the file onto the unix server. Did you NDM it straight from Mainframe. Or you saved it on a windows file server and then ftp'd it?
How did you ftp it. Did you use the internet explorer or command line?
If you used internet explorer then you need to run the command DOS2UNIX on the file. There could be many things, investigate and let us know.![Smile :)](./images/smilies/icon_smile.gif)
How did you ftp it. Did you use the internet explorer or command line?
If you used internet explorer then you need to run the command DOS2UNIX on the file. There could be many things, investigate and let us know.
![Smile :)](./images/smilies/icon_smile.gif)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Are you able to look at the file in a text editor that will allow you to look at the EOR characters?
If so, determine whether the record ends with just x0A (UNIX) or x0D0A (DOS).
If it is the latter, your FTP has not transferred the file in the proper format.
Sorry if I'm belabouring this point, but everytime I've had this error, it has been because of those pesky EOR indicators.
Rob W.
If so, determine whether the record ends with just x0A (UNIX) or x0D0A (DOS).
If it is the latter, your FTP has not transferred the file in the proper format.
Sorry if I'm belabouring this point, but everytime I've had this error, it has been because of those pesky EOR indicators.
Rob W.
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com