Archives of the TeradataForum
Message Posted: Fri, 20 Jul 2007 @ 17:45:38 GMT
| 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....