Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 10:35:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Everybody,

I tried to fastload the table in file sam1.txt (which i genrated from fastExport.

sam1.txt

"  1003       tim        tim
"  1001       sam        sam
"  1002       tom        sam

now when I run this fastload script the frist column is not loaded in the table fload?

Script:->

logon demo/sam,sam;

create table sam.fload
    ( a char(12),
      b char(11),
      c char(11));

define  a (char(12)),
        b (char(11)),
        c (char(11))
File=c:\sam1.txt;

show;

begin loading sam.fload
  errorfiles sam.err1, sam.err2 ;

insert into sam.fload values
         (:a,
          :b,
          :c);

end loading;

logoff;

please tell me what am i doing wrong?

Thank you,

Satya

Have A Nice Day :-)

	<Prev	Next>		<<First	<Prev	Next>	Last>>