Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2010 @ 09:51:58 GMT


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


Subj:   Re: Pros and Cons of Stored Procedures
 
From:   Faible Mou

Cesar Ureta wrote:

  ending up with 5000 line stored procedures that aborted and not being able to figure out what went wrong.  


Thanks for everyone who responded.

Interesting, no one is mentioning what I was expecting for. I heard some companies are avoiding stored procedures because they only run on single AMPs. Is that true?

Moreover, are stored procedures like marcos, in the sense that the whole procedure is regarded as a single transaction, and will rollback the whole thing if anything goes wrong?


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: 15 Jun 2023