Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 May 2003 @ 18:30:47 GMT


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


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.



     
  <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: 15 Jun 2023