Hi all,
I am using a fixed width file, which has only one column of length 200.
I have some records which have length as 30,some as 45 some as 90 and some as 40.
When i run this job, i get the following fatal error :
Sequential_File_11,0: Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).
the schema details are as below :
Record Level-
record length =fixed
Field defualts
Delimiter = none
pls help me in solving this.
fixed widht file problem
Moderators: chulett, rschirm, roy
Re: fixed widht file problem
vij wrote:Hi all,
I am using a fixed width file, which has only one column of length 200.
I have some records which have length as 30,some as 45 some as 90 and some as 40.
When i run this job, i get the following fatal error :
Sequential_File_11,0: Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).
the schema details are as below :
Record Level-
record length =fixed
Field defualts
Delimiter = none
pls help me in solving this.
From your post I get an impression like your file is not fixed width, hence you cannot use the same.
If you really have a fixed width file, it will most probably be a data problem, check out the data file and find if the lengths are correct.
You need to know your column and line separators and the data types (and max lengths) for all your columns. Put those into the stage and you will be all set.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India