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.
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India