Fastload Demo script doesn't work

Database
Enthusiast

Fastload Demo script doesn't work

Hi, I am a new learner of Teradata. When I try using the demo script provided by "Teradata Fastload Reference" (2911.pdf) p28, I got the error as:

**** 10:14:13 Number of recs/msg: 698                                      

**** 10:14:13 Starting to send to RDBMS with record 1                      

**** 10:14:13 Incorrect number of bytes returned from a File Read!         

              Expected: 84, Received: 10                                   

**** 10:14:13 Error at record number 6                                     

     ===================================================================   

     =                                                                 =   

     =          Logoff/Disconnect                                      =   

     =                                                                 =   

     ===================================================================   

**** 10:14:13 Logging off all sessions                                     

**** 10:14:14 Total processor time used = '0.265625 Seconds'               

     .        Start : Fri Dec 05 10:14:12 2014                             

     .        End   : Fri Dec 05 10:14:14 2014                             

     .        Highest return code encountered = '12'.                      

**** 10:14:14 FastLoad Paused                                            

The script is:

sessions 2;

errlimit 25;

logon 172.16.82.143/dbc,dbc;

DATABASE TBL_DB;

drop table employeeT;

drop table error_1;

drop table error_2;

CREATE TABLE TBL_DB.employeeT (

EmpNo SMALLINT FORMAT '9(5)' BETWEEN 10001 AND 32001 NOT NULL,

Name VARCHAR(12),

DeptNo SMALLINT FORMAT '999' BETWEEN 100 AND 900,

PhoneNo SMALLINT FORMAT '9999' BETWEEN 1000 AND 9999,

JobTitle VARCHAR(12),

Salary DECIMAL(8,2) FORMAT 'ZZZ,ZZ9.99' BETWEEN 1.00 AND 999000.00,

YrsExp BYTEINT FORMAT 'Z9' BETWEEN -99 AND 99,

DOB DATE FORMAT 'MMMbDDbYYYY',

Sex CHAR(1) UPPERCASE,

Race CHAR(1) UPPERCASE,

MStat CHAR(1) UPPERCASE,

EdLev BYTEINT FORMAT 'Z9' BETWEEN 0 AND 22,

HCap BYTEINT FORMAT 'Z9' BETWEEN -99 AND 99 )

UNIQUE PRIMARY INDEX( EmpNo );

set record unformatted;

define

delim0(char(1)),

EmpNo(char(9)), delim1(char(1)),

Name(char(12)), delim2(char(1)),

DeptNo(char(3)), delim3(char(1)),

PhoneNo(char(4)), delim4(char(1)),

JobTitle(char(12)), delim5(char(1)),

Salary(char(9)), delim6(char(1)),

YrsExp(char(2)), delim7(char(1)),

DOB(char(11)), delim8(char(1)),

Sex(char(1)), delim9(char(1)),

Race(char(1)), delim10(char(1)),

MStat(char(1)), delim11(char(1)),

EdLev(char(2)), delim12(char(1)),

HCap(char(2)), delim13(char(1)),

newlinechar(char(1))

file=insert.input;

show;

begin loading TBL_DB.employeeT errorfiles TBL_DB.error_1, TBL_DB.error_2;

insert into TBL_DB.employeeT (

:EmpNo,

:Name,

:DeptNo,

:PhoneNo,

:JobTitle,

:Salary,

:YrsExp,

:DOB,

:Sex,

:Race,

:MStat,

:EdLev,

:HCap

);

end loading;

logoff;

The input file is:

|10021    |Brown, Jo   |200|2312|Development |63000.00 |20|Jan 01 1955|F|W|M|16| 0|

|10001    |Jones, Bill |100|5376|President   |83000.00 |15|Jan 01 1960|M|W|M|14| 0|

|10002    |Smith, Jim  |100|4912|Sales       |73000.00 |10|Jan 01 1970|M|W|M|13| 1|

|10028    |Lee, Sandra |200|5844|Support     |77000.00 | 4|Jan 01 1971|F|W|M|18| 0|

|10029    |Berg, Andy  |200|2312|Test        |67000.00 |10|Jan 01 1967|M|W|M|15| 0|

|10023    |Ayer, John  |300|4432|Accounting  |52000.00 | 8|Jan 01 1965|M|W|M|13| 0|

Is there anyone can help me?

Thanks in advance!

Tags (1)