Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Aug 2012 @ 14:35:08 GMT


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


Subj:   Re: Mload layout in unix
 
From:   Diehl, Robert

Here is an example that puts the multiload. Mload script produced has some things to change like databasename, tablename, logon.

     .logtable logdatabasenem.tablename_flog;


     /* source system logon info */

     .logon dbs/username,password;


     .begin export

     sessions 4;


     /* name of fast export data file, change for new fast export */

     .export outfile /filelocation/databaasename.tablename.dat

     mode indicator format fastload


     /* multiload script, change the name for new multiload*/

     MLSCRIPT /filelocation/databasename.tablename.ml;


     /* source table */

     LOCKING ROW FOR ACCESS

     sel * from databasename.tablename

;

     .end export;

     .logoff;

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA



     
  <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: 23 Jun 2019