Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Sep 2013 @ 10:22:44 GMT


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


Subj:   Re: Global temporary space usage
 
From:   Dieter Noeth

narayan.murthy wrote:

  Compiling the topmost procedure should compile all the nested guys.  


Well, this doesn't answer the question and it doesn't work, too :-)

As there's no built-in way (beside SHOW PROCEDURE xy) to get the source code of a SP, it's up to the developer of the SP to determine the order.

Otherwise Teradata's Metadata Services (MDS) should be able to return that info.

Of course, all will fail if the SP is created without source code (ok, in this case you can't recreate it).


Dieter



     
  <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