Archives of the TeradataForum
Message Posted: Wed, 28 May 2003 @ 18:30:47 GMT
| Subj: || || Using/passing variables/parameters with BTEQ when creating |
| From: || || Paul Swier |
Well here goes another day another question for the group.
I am looking for a way that I can create a script to create views in BTEQ or any other Teradata utility. I am going to be setting up
views of databases and would like to be able to pass in the variable/parameter of the database name of where the table is located that the
view will be created from. The view will be in a seperate database than where the tables are located, hence the reason for needing to put
dbname.tablename. I hope I explained this well enough I am still pretty new to Teradata.
Any help would be greatly appreciated.