Re: Is SQL cursor open?

[Jimmy Sansi <jsansi@xxxxxxxxx>]

This has been bugging me for a few days ... though not as simple as you
want: 

QUSRJOBI API and QSYS2.ACTIVE_JOB_INFO() will list the jobs open
cursor(s) 

On 2021-11-08 11:05, Justin Taylor wrote:

> In this case, it should be open, but in rare cases it's not.  I'm looking
> for an easy way to trap for this.
>
> Thanks
>
> date: Mon, 8 Nov 2021 17:52:39 +0100 
>
> > from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
> > subject: RE: Is SQL cursor open?
> >
> > I normally close it before I open it, ... but not everybody loves this.
> >
> > If you are in an procedure you also can close the cursor after ON-EXIT.
> > Then it is always closed (independent of the procedure ends norally or
> > abnormally), i.e. no need to check anymore.
> >
> > Mit freundlichen Gr??en / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training them
> > and keeping them!"
> > ?Train people well enough so they can leave, treat them well enough so they
> > don't want to.? (Richard Branson)