Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 25 Feb 2008 @ 14:52:41 GMT





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




Subj:   Re: Stored Procedure error SPL1031
 
From:   Hassinger, Bill



Thanks to all responders for input:

We are on version V2R6.1.1 and the alias problem was solved when I created the SP from SQLAssistant 7.1 instead of 7.2.

I changed to dynamic SQL for the revoke statement and the procedure compiled.


    Bill H




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