Fastload Error

Tools & Utilities
Enthusiast

Fastload Error

 
3 REPLIES
Enthusiast

Re: Fastload Error

Hi,

I am getting error while running fastload command on unix terminal. below the error message: Highest return code encountered = '12'

The script is  as below:

.LOGON database_name/username,password;

drop table abc;

create table abc

(emp_no int

,dept_no smallint

,last_nm varchar(20)

,first_nm varchar(20)

,sal decimal(15,2))

unique primary index(emp_no);

set record vartext ",";

define emp_no (varchar(20))

,dept_no (varchar(20))

,last_nm (varchar(20))

,first_nm (varchar(20))

,sal (varchar(20))

file = 'emp_table.txt';

show;

begin loading abc

errorfiles abc_err, abc_err1

checkpoint 1;

insert into abc (emp_no

,dept_no

,last_nm

,first_nm

,sal)

values

(:emp_no

,:dept_no

,:last_nm varchar(20)

,:first_nm

,:sal);

end loading;

logoff;

As a trial i m trying to insert 2 records only first:

1,2,jones,alex,52000

2,6,dykes,john,86000

I get this error in insert phase.

Please suggest.

Thanks,

Rohit

Teradata Employee

Re: Fastload Error

I do not see any error.

Please provide the error you receive.

-- SteveF
Enthusiast

Re: Fastload Error

Thanks for reply Steve but i was able to figure out the problem and now it's resolved.