Problem in loading data with Fastload

Tools
Enthusiast

Problem in loading data with Fastload

Hi,
I am getting the following problem while loading flat file data into a table
using fastload.

''Incorrect number of bytes returned from File Read,
Expected 2072,Recieved 500.''
Return code 12.

I have 2072 bytes of data in the flat file,eventhough few null columns in between.
I can load the same file with a multiload script,but fastload gives this error.

Please help.
4 REPLIES
Enthusiast

Re: Problem in loading data with Fastload

Are you using INDICATOR mode??

try setting the separator which your flat file uses.
SET RECORD VARTEXT ",";

remove INDICATORS from the begin loading, if your flat file is pure text mode.

BEGIN LOADING sarathy_db.emp
ERRORFILES sarathy_db.fld_err_tb1,sarathy_db.fld_err_tb2
INDICATORS <--------
CHECKPOINT 50;
Enthusiast

Re: Problem in loading data with Fastload

Hi,

I am not using indicator mode.
My flat file data is of fixed length.
Please try to help me.

Regards,
Aravind
Enthusiast

Re: Problem in loading data with Fastload

could u pls post a extract of the script u use?
Enthusiast

Re: Problem in loading data with Fastload

hi,
I have solved the problem.thanks for ur suggestions.
The problem was,in the record format,i had given 'unformatted' in place of 'text'.

Regards,
Aravind Hegde