Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Jul 2007 @ 17:45:38 GMT

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

Subj:   Re: Enhancements or Improvements to Stored Procedures
From:   Geoffrey Rommel

  One thing I do find difficult is stepping through a SP, particularly when it's not doing what you expect it to do.  

No kidding! Actually, this would be a great opportunity for some intrepid software developer (Dave Wellman, maybe?) -- an interactive debugger that simulates a SP. Then you could develop and debug the code before putting it in the database.

  Is there any way of defining functions, for example, which returns a value, or is this effectively just another SP which is invoked from within the main SP ?  

Don't know what you mean here. UDF's can return values, but you seem to be asking something else.

  In simple terms what does ITERATE do with LOOP.  

It returns to the top of the loop, like 'break' in C.

  here's a little technique  

I like it!

  Also, I take it that there's no easy way of returning a result set of values, like an array or, even better, an object ?  

Table UDF's will do this. I haven't looked into them, though.

  Any 'nougats' of wisdom would be appreciated  

I think mine are just nuggets....

  <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