Re: close result set from stored procedure

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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