Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Jun 2005 @ 17:52:12 GMT


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


Subj:   Fastload syntax errors: 3808
 
From:   Capp.Luckett

HI:

I am trying to get Fastload to work for the mainframe but I seem to be getting syntax errors I can't seem to resolve.

Do I need to define the EORRORFILE tables? If so, where do I find how they should be defined. The manual did not state.

My script looks like:

     .LOGON TDPP/A,xxx
     .SHOW                                     ;
     .SESSIONS 4                               ;
      BEGIN LOADING HCCLCO_USHARE.FASTLOAD_TEST
            ERRORFILES ERRNAME1, ERRNAME2;
       DEFINE KEYCL (CHAR(9)),
       DDNAME=INFILE;
       INSERT INTO HCCLCO_USHARE.FASTLOAD_TEST (KEYCL) VALUES (:KEYCL);
     .LOGOFF
     .EXIT


     **** 10:13:57 RDBMS error 3808: Database unspecified for 'ERRNAME1'.

Thanks

Capp Luckett



     
  <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