Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 05 Jul 2003 @ 16:02:54 GMT


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


Subj:   Re: Another FastExport and FastLoad question (syntax)
 
From:   Robert D Meunier

The following are examples that I've used on MVS but should work for network attached systems.

---------------------------------------------------
FASTEXPORT:
.LOGON ;
.LOGTABLE WORKDB.TABLELOG;
.BEGIN EXPORT;

  SELECT *
   FROM EDW.CURRENCY;

  .EXPORT OUTFILE EXPOUT MODE INDICATOR;
  .END EXPORT;
  .LOGOFF;

----------------------------------------------------
FASTLOAD:
.LOGON ;
ERRLIMIT 1;
BEGIN LOADING
    WORKDB.CURRENCY
    ERRORFILES
      WORKDB.CURRENCY_ERR1,
      WORKDB.CURRENCY_ERR2
      INDICATORS
      CHECKPOINT 100000;
DEFINE

     DDNAME = INFILE;
     HELP TABLE WORKDB.CURRENCY;
     SHOW;
INSERT INTO EDW.CURRENCY.*
;

END LOADING;
LOGOFF;
.QUIT;

----------------------------------------------------

The "HELP TABLE" will only work if the table to be loaded is EXACTLY the same as the one you extracted from. Otherwise you'll need to DEFINE the columns.

The other option is to do a FASTEXPORT with a MLSCRIPT option on the EXPORT command. This will generate a MultiLoad script which you can then use to load the data.

Robert Meunier



     
  <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: 15 Jun 2023