Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Wed, 04 Feb 2004 @ 14:43:23 GMT





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




Subj:   Re: Stored Procedures - Pros & Cons
 
From:   Harold D Kleven



We have one application that is heavily vested in SPs. They took the approach - and we didn't stop it - of coding specific application logic in the SPs and a lot of SQL in each. The SPs are not, generally, reusable units. I would recommend NOT taking that approach because I personally favor simple, reusable code units and, more importantly, there are no debugging aids for SPs. And TSET can't handle a SP.





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