Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Jun 2007 @ 20:18:46 GMT


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


Subj:   Stored Procedure execution mode
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, June 20, 2007 14:09 -->

We have many stored procedures created by different users. Some procedures are compiled with SPL and some are with NOSPL.

Can anybody tell me how can I find which procedures are compiled with SPL and NOSPL? It is difficult and time consuming to do "SHOW PROCEDURE" for each and every procedure. Is there any DBC view which can give this information? FYI.. We are on V2R6.1


Thanks



     
  <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: 27 Dec 2016