Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   FastLoad script not loading first column
 
From:   Satish Gadbail

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016