 |
 |
Archives of the TeradataForum
Message Posted: Wed, 05 Nov 2003 @ 13:28:50 GMT
| Subj: | | Re: Nested Cursor |
| |
| From: | | Geoffrey Rommel |
| | Is it Ok to declare the Inner cursor again and again? or is there any other method do it properly. | |
As the manual explains, "declare cursor" is a declarative, not an executable, so it is only processed once by the precompiler; it
is not executed at run time (SQL Ref., Vol. 6). The open, fetch, and close, however, will have to be executed every time.
Is it possible to rewrite these two selects as a join? Then you would only need one cursor.
| |
