Archives of the TeradataForum
Message Posted: Thu, 08 Aug 2002 @ 12:27:44 GMT
| Subj: | | Re: Passing in table name to FASTLOAD |
| |
| From: | | Geoffrey Rommel |
| | Can you pass in the tablename to FASTLOAD? | |
| | 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.
| 
