Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Nov 2005 @ 14:40:47 GMT

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

Subj:   Re: Stored procedures results
From:   Geoffrey Rommel

  I have just started exploring the stored procedures and after working extensively with batch scripts for 5 years have found out that there is no way of capturing the intermediate results in the body of the SP. What a disappointment !!  

Yes, annoying, isn't it? The only way to see intermediate results is to put them in a separate work table. This would work best if you were just writing an occasional log message.

Procedures have their place, but I generally discourage their use, and this is one reason why.

  <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