Mload Script Error

Tools

Mload Script Error

Hi guys!

I´m having a problem with my Mload script:
------------------------------------------------------
.LOGTABLE mydatabase.logtable;
.LOGON ;

DATABASE mydatabase;

CREATE TABLE mydatabase.MYTABLE
(
IDFIELD INTEGER NOT NULL,
CODEFIELD INTEGER NOT NULL)
PRIMARY INDEX ( COD_COLETA );

.BEGIN IMPORT MLOAD TABLES MYTABLE SESSIONS 2;

.LAYOUT inslayout;
.FIELD IDFIELD * varchar(10);
.FIELD CODEFIELD * varchar(10);

.DML LABEL insdml;
INSERT INTO MYTABLE .*;

.IMPORT INFILE D:\Temp\Olympio\Data.txt
FORMAT VARtext ','
LAYOUT inslayout
APPLY insdml;
.END MLOAD;
.LOGOFF;
------------------------------------------------------
Data.txt has this data:
-------------------------
123456,1

-----------------------
This error appears:

What can I do to solve this problem?

Thanks for help,
Anderson

2 REPLIES
N/A

Re: Mload Script Error

Hi!

.BEGIN IMPORT MLOAD TABLES MYTABLE SESSIONS 2;
in the above line fo your code you need to mention 2 error tables and one working tables.
it looks like this:
.BEGIN IMPORT MLOAD TABLES MYTABLE
ERRORTABLES ERR1 ERR2
WORKTABLES WT_TABLE

SESSIONS 8;

MODIFY AND RUN THIS IT SHOULD WORK.
LET ME KNOW IFIT DOESN'T?//

Re: Mload Script Error

It really runs man!!

Thank you so much for help!!