Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023