FASTLOAD ERROR

Database

FASTLOAD ERROR


Hi,

I have been trying to load this file using fast for more than 2 weeks, it's a text(.txt) file containing the following data with no header:

001$sharon$stone X'0D0A'
002$demi$moore X'0D0A'
003$drew$barrymore X'0D0A'
004$julia$roberts X'0D0A'
005$cameron$diaz X'0D0A'
006$homer$simpson X'0D0A'

The fast load script is hereunder:
sessions 2;
errlimit 25;
logon localtd/dbc,dbc;
DATABASE SAMPLES;

create table stars (sid int, fname char(20), lname char(20));

BEGIN LOADING stars
ERRORFILES
ERRORTABLE1,
ERRORTABLE2;

SET RECORD VARTEXT "$" ;
DEFINE
sid (VARCHAR(10)),
fname (VARCHAR(20)),
lname (VARCHAR(20))

FILE=C:\Users\User\Documents\Buju\Fast_Load_Dataames.txt;

INSERT INTO stars
VALUES (
:sid ,
:fname,
:lname
);

.END LOADING;

I am getting the following error message, and it's getting quite frustrating. Any help would be highly appreciated:

DATABASE SAMPLES;
0018 DATABASE SAMPLES;

**** 02:30:09 Command completed successfully

FastLoad - Enter your command:

create table stars (sid int, fname char(20), lname char(20));
0019 create table stars (sid int, fname char(20), lname char(20));

**** 02:30:09 Command completed successfully

FastLoad - Enter your command:

BEGIN LOADING stars
ERRORFILES
ERRORTABLE1,
ERRORTABLE2;
0020 BEGIN LOADING stars
ERRORFILES
ERRORTABLE1,
ERRORTABLE2;

**** 02:30:10 RDBMS error 2635: Error tables are invalid OR stars is in
an invalid state for Load -

FastLoad - Enter your command:

SET RECORD VARTEXT "$" ;
0021 SET RECORD VARTEXT "$" ;

**** 02:30:10 SET RECORD VARTEXT may only be specified one time

FastLoad - Enter your command:

DEFINE
sid (VARCHAR(10)),
fname (VARCHAR(20)),
lname (VARCHAR(20))

FILE=C:\Users\User\Documents\Buju\Fast_Load_Dataames.txt;
0022 DEFINE
sid (VARCHAR(10)),
fname (VARCHAR(20)),
lname (VARCHAR(20))

FILE=C:\Users\User\Documents\Buju\Fast_Load_Dataames.txt;

**** 02:30:10 Duplicate element name - SID
**** 02:30:10 Duplicate element name - FNAME
**** 02:30:10 Duplicate element name - LNAME
**** 02:30:10 FDL4822 DEFINE statement rejected.
**** 02:30:10 FDL4811 FILE (DDNAME) or INMOD already specified

FastLoad - Enter your command:

INSERT INTO stars
VALUES (
:sid ,
:fname,
:lname
);
===================================================================
= =
= Insert Phase =
= =
===================================================================

0023 INSERT INTO stars
VALUES (
:sid ,
:fname,
:lname
);

**** 02:30:10 RDBMS error 3706: Syntax error: expected something
between ';' and the 'USING' keyword.
**** 02:30:10 Update failed for SYSADMIN.FASTLOG table

FastLoad - Enter your command:

.END LOADING;
===================================================================
= =
= End Loading Phase =
= =
===================================================================

0024 .END LOADING;

**** 02:30:19 RDBMS error 3614: Statement permitted only during
FastLoad or MLoad.
**** 02:30:19 FastLoad will attempt to retry this request 5 time(s)
**** 02:30:20 Teradata Database Release: 12.00.00.10
**** 02:30:20 Teradata Database Version: 12.00.00.10
**** 02:30:20 Current CLI or RDBMS allows maximum row size: 64K
**** 02:30:20 Character set for this job: ASCII
**** 02:30:21 Number of FastLoad sessions connected = 2
**** 02:30:21 FDL4808 LOGON successful
**** 02:30:21 The last checkpoint was taken at row: 0
**** 02:30:21 FastLoad will now restart at row: 1
**** 02:30:21 RDBMS error 2719: FASTLOAD END LOADING cannot be inside
the Data Loading phase.

FastLoad - Enter your command:

Thanks
Bidyut