Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2011 @ 10:49:09 GMT


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


Subj:   FLOAD Query Syntax Error
 
From:   Samikkumar Kiritkumar Shah

     .LOGON 10.163.112.11/username,pass;

     .SET RECORD VARTEXT ",";


     DEFINE
         CIRCLE_ID (VARCHAR(50)),
         TYPE_NAME (VARCHAR(50)),
         CATEGORY (VARCHAR(50)),
         TRANSACTION_DATE (VARCHAR(50)),
         TOTAL_VALUE (VARCHAR(50))

     FILE=D:\Samik\RADB.txt;
     show;
     BEGIN LOADING DP_TMP.DS0004_RADB_01_BSCS RRORFILES
     DP_TMP.ERR1,DP_TMP.ERR2
     CHECKPOINT 5;
     INSERT INTO DP_TMP.DS0004_RADB_01_BSCS VALUES
           (:CIRCLE_ID,
            :TYPE_Name ,
            :CATEGORY,
            :TRANSACTION_DATE,
            :TOTAL_VALUE );
     END LOADING;
     LOGOFF;

IN ABOVE FLOAD SCRIPT I AM Getting following error

     **** 14:46:09 Expected FORMATTED, UNFORMATTED, TEXT, BINARY or
                   VARTEXT after RECORD keyword.
          -------------------------------------------------------------------
          -                                                                 -
          -          Logoff/Disconnect                                      -
          -                                                                 -
          -------------------------------------------------------------------

     **** 14:46:09 Logging off all sessions
     **** 14:46:14 Total processor time used = '1.04688 Seconds'
          .        Start : Tue Mar 15 14:45:57 2011
          .        End   : Tue Mar 15 14:46:14 2011
          .        Highest return code encountered = '8'.
     **** 14:46:14 FDL4818 FastLoad Terminated

Can you please help me to resolve.


Thanks,

Samikjumar Shah



     
  <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