Hello experts,
This is the error I encountered while executing a fastload script:
TDExpress14.10.01_Sles10:~ # fastload <fastload.fld
===================================================================
= =
= FASTLOAD UTILITY VERSION 14.10.00.04 =
= PLATFORM LINUX =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2013, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 10:51:59 Processing starting at: Wed Nov 25 10:51:59 2015
0001 .sessions 4;
**** 10:51:59 FDL4866 SESSIONS command accepted
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0002 .logon 127.0.0.1/dbc,
**** 10:51:59 Teradata Database Release: 14.10.01.02
**** 10:51:59 Teradata Database Version: 14.10.01.01
**** 10:51:59 Number of AMPs available: 2
**** 10:51:59 Current CLI or RDBMS allows maximum row size: 64K
**** 10:51:59 Character set for this job: ASCII
0003 set record vartext ",";
**** 10:52:00 Now set to read 'Variable-Length Text' records
**** 10:52:00 Delimiter character(s) is set to ','
**** 10:52:00 Command completed successfully
0004 begin loading retail.employee;
**** 10:52:00 Number of FastLoad sessions requested = 4
**** 10:52:00 Number of FastLoad sessions connected = 2
**** 10:52:00 FDL4808 LOGON successful
**** 10:52:00 RDBMS error 3706: Syntax error: expected something
between the word 'employee' and the 'WITH' keyword.
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 10:52:00 Logging off all sessions
**** 10:52:00 Total processor time used = '0.24 Seconds'
. Start : Wed Nov 25 10:51:59 2015
. End : Wed Nov 25 10:52:00 2015
. Highest return code encountered = '12'.
**** 10:52:00 FDL4818 FastLoad Terminated
And this is my fastload script:
.sessions 4;
.logon 127.0.0.1/dbc,dbc;
set record vartext ",";
begin loading retail.employee;
define
Empno (varchar(15))
Empname (varchar(18))
Address (varchar(40))
Phone (varchar(15))
Deptno (varchar(2))
Salary (varchar(12))
YrsExp (varchar(1))
DOB (varchar(10))
Medstat (varchar(1))
Edllev (varchar(1))
Note (varchar(79))
File = Incoming.txt;
Insert into retail.employee
values(
:Empno,
:Empname,
:Address,
:Phone,
:Deptno,
:Salary,
:YrsExp,
:DOB,
:Medstat,
:Edllev,
:Note
);
end loading;
.logoff;
I am trying to load the retail.employee database that comes as a sample in Teradata 14.10.01. Can somebody please help me to figure out where the error is. Please....
