Archives of the TeradataForum
Message Posted: Sun, 25 Nov 2002 @ 03:39:49 GMT
Subj: | | HELP TABLE COMMAND in FastLoad Script |
|
From: | | Madhu Reddy |
Hi,
I am trying following fastload script with HELP TABLE in define statement....
I am getting following error...
********** 21:35:13 The length of: NAME in row: 1 was greater than defined.
Defined: 12, Received: 16723
***********************************
Followinf is my emp11.txt input file
20AAAAAAA 1234
21Madhu 4534
Does anybody have any idea, what is this error? is my following script is correct?
_____________________________________________________
sessions 2;
errlimit 25;
logon demo1099/madhu1,madhu1;
CREATE TABLE emp1 (
Empno SMALLINT,
Name VARCHAR(12),
PhoneNo SMALLINT)
UNIQUE PRIMARY INDEX (EMPNo);
set record text;
begin loading emp1 errorfiles error_1, error_2;
HELP TABLE emp1;
define file= emp11.txt;
show;
insert into emp1 values (:Empno, :Name, :PhoneNo);
end loading;
logoff;
-----------------------------------------------
|