Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 08 Aug 2002 @ 12:27:44 GMT


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


Subj:   Re: Passing in table name to FASTLOAD
 
From:   Geoffrey Rommel

  Can you pass in the tablename to FASTLOAD?  


  I want to  


  DROP tablename
CREATE tablename
FASTLOAD tablename
 


  but I want tablename to be a variable.  



You can't do this directly in FastLoad. You could do this with MultiLoad like so:

.accept tablename from file /any/old/file; [or from an env. variable]
drop table &tablename;
create table &tablename ...;
etc.


Or you could write a program, possibly in Perl, to create the FastLoad script and then run it.



     
  <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