Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 Jun 2002 @ 22:33:10 GMT

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

Subj:   Re: Using the mlscript option in FastExport without running the export
From:   Doug Drake


Use an OUTLIMIT parameter of 0 in the .EXPORT statement as shown below.

.export outfile "Fexp Pty Cl RB.data" mode record Outlimit 0 Mlscript "ML Pty Cl RB.txt";

This runs through all of the FastExport commands including cranking up all of the requested sessions so it takes 30 seconds or so but it does not actually export any data.

Maybe a better option to consider is to use Jim Calvert's freeware called InTeraScript which has the capability to generate Fastload and Multiload scripts based off of any table. His website and all the goodies can be found at www.members.rogers.com....


Doug Drake

  <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: 28 Jun 2020