Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 28 Oct 2002 @ 15:41:04 GMT





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




Subj:   Re: Variables as Table Name(s) in Stored Procedure
 
From:   Jason Fortenberry



Yes, there is a slight catch for using SP. The procedure has to be created under a User database (the creator and immediate owner have to be the same) and this user db has to have some perm space. So prefix your procedure name with your user_id.





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008