|
|
Archives of the TeradataForum
Message Posted: Fri, 19 Jun 2009 @ 16:35:45 GMT
Subj: | | Re: Database and tablename - BTEQ |
|
From: | | Michael Larkins |
| This isn't a feature available within Bteq. If you need to use parameters for object names in your Bteq script then you'll need to do those
outside of Bteq, typically using a shell script or windows command script. | |
Although this is true of BTEQ, you could consider using the start-up (Preliminary Phase) of MLOAD, FastExport or TPump to do this type of
parameter substitution. There is even a .ACCEPT command that would allow you to read a parameter record to obtain the names to substitute for
either database objects or parameters anywhere within the SQL. The trick is that you do not even need to use a .BEGIN to actually start the
utility. Pretty cool and powerful.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |