TPUMP ERROR

Tools

TPUMP ERROR

Hello All,

My Script:

.LOGTABLE samples.errors;

.logon 127.0.0.1/dbc,dbc;

.begin load sessions 8;

.layout Emp_TBL;

.FIELD empno * integer key;

.FIELD empname * varchar(10);

.FIELD mob * bigint;

.FIELD doj * date;

.FIELD Deptno * integer;

.DML LABEL Emp_Ins;

insert into retail.emp values

(:empno,:empname,:mob,:doj,:Deptno);

.import infile 'C:\TD\emp_export.txt'

layout Emp_TBL

APPLY Emp_Ins;

end load;

logoff;

Error:

0013 end load;

**** 19:34:11 UTY6621 Unrecognized DML keyword.

Please help!!!

Thanks,

Tushar

2 REPLIES
Teradata Employee

Re: TPUMP ERROR

Missing the leading "." for ".end load;" command

Re: TPUMP ERROR

Thanks!!!