All Forums Tools
Rohit Ranjan 20 posts Joined 05/12
17 Aug 2015
Fastload Error
Rohit Ranjan 20 posts Joined 05/12
17 Aug 2015

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
 

feinholz 1234 posts Joined 05/08
17 Aug 2015

I do not see any error.
Please provide the error you receive.
 

--SteveF

Rohit Ranjan 20 posts Joined 05/12
17 Aug 2015

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

You must sign in to leave a comment.