fastload error:

Database
Enthusiast

fastload error:

Hi,
These are my fast export and fast load sripts which I am trying to use to load from one table to the other. The definition of the source table was copied to create the target table. But still I get the error as:

##################################################################
===================================================================
= =
= Insert Phase =
= =
===================================================================

0011 INSERT database2.tablename.*;

**** 21:12:19 Number of recs/msg: 431
**** 21:12:19 Starting to send to RDBMS with record 1
**** 21:12:19 RECORD is too long by 134 byte(s)

####################################################################

These are the scripts:

Fast Export:
============
.LOGTABLE logtablename;
.LOGON database1/uname,pwd;
.BEGIN EXPORT ;
.EXPORT OUTFILE filename format binary;
locking tablename for ACCESS
select * from databasename1.tablename sample 20000;
.END EXPORT;
.LOGOFF;

#################
FastLoad
#################
SESSIONS 4;
RECORD 1 THRU 20000;
ERRLIMIT 25;
LOGON database2/uname,pwd;
DROP TABLE Error1;
DROP TABLE Error2;
SHOW;
BEGIN LOADING tablename2
ERRORFILES Error1,Error2
CHECKPOINT 10000;
DEFINE FILE = filename;
INSERT database2.tablename.*;
END LOADING;
LOGOFF;

Please let me know if you have seen this before and know the solution to my problem.
Thanks.
3 REPLIES
Enthusiast

Re: fastload error:

use

FORMAT FASTLOAD

in your export script.
Enthusiast

Re: fastload error:

I tried this but its still giving me the same error.
In the load script i am using
set record formatted.
Is that the right way?
Enthusiast

Re: fastload error:

You may also need to use the INDICATORS keyword in your begin loading statement.