Re: close result set from stored procedure

Something fishy about how you've coded the SP/UDTF...or perhaps how you are
running the SP/UDTF..

When you run your next statement, the result set should be closed
automatically.

I have no issues running a UDTF that builds a global temporary table and
returns a cursor to it multiple times.

Are you running under commitment control perhaps, especially a higher
level, and probably don't need to be at all?

Charles

On Tue, May 7, 2019 at 9:19 AM Darren Strong <darren@xxxxxxxxx> wrote:

I've called a stored procedure, such as below from the STRSQL interface.
If I call again, I get an error saying that a file in QTEMP cannot be
cleared because its in use. Is there an SQL command to deallocate or close
a result set to indicate back to the stored procedure that I'm done with
the result set, if I didn't use a HLL to read the cursor?

CALL QSYS2.DISPLAY_JOURNAL_ENTRY_INFO(
2,'#MXJRN','BPCS_ALL',21120741,'#MXJRN','ALLRCV7602','PT')
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com