Fastload issue

Tools
Enthusiast

Fastload issue

I'm trying to load a table dump exported with fastexport, but i get the following error:

The length of: PREFIX in row: 1 was greater than defined.
Defined: 3, Received: 3072

Here are my fastexport and fastload scripts:

.LOGTABLE dbase.some;
.LOGON some/some,some;

.BEGIN EXPORT;

.EXPORT OUTFILE "fexp.data" FORMAT FASTLOAD;
SELECT * from dbase.tablename;
.END EXPORT;

.LOGOFF;

and the fastload script:

 SESSIONS 4;
.LOGON some/some,some;

DROP TABLE dbase.Error_1;
DROP TABLE dbase.Error_2;

DEFINE FILE=fexp.data;
BEGIN LOADING dbase.tablename ERRORFILES dbase.Error_1, dbase.Error_2;
INSERT INTO dbase.tname.*;
END LOADING;

.LOGOFF

Any idea, what could be the problem?

1 REPLY
Junior Contributor

Re: Fastload issue

FastExport defaults to MODE INDICATOR to deal with NULLs, but FastLoad doesn't.

So either modify

the FExp (if there are no NULLs):

.EXPORT OUTFILE "fexp.data" FORMAT FASTLOAD MODE RECORD;

or the FastLoad (if there are NULLs):

BEGIN LOADING dbase.tablename ERRORFILES dbase.Error_1, dbase.Error_2 INDICATORS;

Dieter