 |
 |
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....
| |
