Re: SQL Cursors and recursive procedures

[Bradley Stone <bvstone@xxxxxxxxx>]

You know, now that I think back, Jon was mentioning on newer OS you can use
the same cursor definition in different subprocedures.  My mistake.

I did end up using RLA for the solution, and it actually was a lot cleaner
in a way.

In my searches for an embedded/dyanmic SQL solution I found a lot of "why
would you want to do that?" reponses.  Well, because recursion in business
logic is rare, but it does happen from time to time and I personally would
rather use the programming language rather than SQL statements.

Bradley V. Stone
www.bvstools.com
GreenTools for PayPal <https://www.bvstools.com/g4pp.html>: Easily send
PayPal invoices from your IBM i applications using RPG ILE! Process
refunds, get account balances and more!

On Sat, Feb 17, 2018 at 11:22 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

> I seem to recall having a chat with Jon Paris (probably on this list)
> about SQL Cursors and not being able to use them recursively.  I've done
> some searching and just can't find that conversation.
>
> Is that still the case on V7R2/3?  Is there any way to set a cursor as
> unique to the recursion level of the call to the function instead of at the
> program level?
>
> If not, besides RLA what other options are there?
>
>
> Bradley V. Stone
> www.bvstools.com
> MAILTOOL Benefit #11 <https://www.bvstools.com/mailtool.html>: Save
> Emails - Save emails that are sent out at a global, user or individual
> email level.