All Forums Tools
veskojl 12 posts Joined 04/12
16 Oct 2012
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?

dnoeth 4628 posts Joined 11/04
17 Oct 2012

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

Dieter

You must sign in to leave a comment.