Yes, you could.

Frankly, if possible, I'd still explicitly close the cursor - to me it's
good practice, but sometimes it's not possible, depending on the
application design.

On Mon, Apr 30, 2012 at 10:09 AM, Jerry C. Adams <midrange@xxxxxxxx> wrote:

Thanks, Rory. That did the trick. Never used that before because,
I use cursors frequently and always CLOSE cursor inside the RPGLE program.
Didn't know I had a cursor in this one since I never DECLAREd one. I'm a
real put putz when it comes to this SQL stuff. The default (at 5.1 anyway)
is *ENDACTGRP. If I had called the program via a CL, I could have used the
RCLACTGRP command to the same effect, right?

Jerry C. Adams
IBM i Programmer/Analyst
We've got to pause and ask ourselves: How much clean air do we need? -Lee
A&K Wholesale
Murfreesboro, TN

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.