Archives of the TeradataForum

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

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

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>>