Re: IBM i 7.5 TR5 and IBM i 7.4 TR11 announcements

https://www.ibm.com/support/pages/node/7169071

The cursor name that is generated for returning the result set of any SQL

table function has always been named SQL_TABLE_CURSOR. This naming

approach

can cause a cursor name collision when multiple SQL table functions are
used within a query. To circumvent a cursor name collision, the FENCED
clause must be used on the SQL table function. However, the FENCED clause
adds overhead to the execution of the table function by forcing it to run
in separate thread.

With this enhancement, the generated cursor name has been modified so it
contains the table function name and the table function's library name,

if

the library name is available. This does not guarantee uniqueness, but
significantly reduces the possibility of a cursor name collision which
increases the likelihood that the NOT FENCED setting can be used.

Table functions must be rebuilt to pick up this change.

HTH,
Charles

On Tue, Oct 8, 2024 at 1:04 PM Darren Strong <darren@xxxxxxxxx> wrote:

The only thing that caught my interest was a passing mention of UDTF
performance and unfenced. I already create unfenced UDTF's, so, what

does

this new thing do? Quoted as follows:

"SQL User Define Table Functions (UDTFs) by providing the option to
generate unfenced NOT.FENCED code, improving performance"


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of

Rob

Berendt
Sent: Tuesday, October 8, 2024 9:14 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: IBM i 7.5 TR5 and IBM i 7.4 TR11 announcements

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


IBM i 7.5TR5
https://www.ibm.com/docs/en/announcements/i-75-tr5
https://www.ibm.com/support/pages/ibm-i-75-tr5-enhancements

IBM i 7.4TR11
https://www.ibm.com/docs/en/announcements/i-74-tr11
https://www.ibm.com/support/pages/ibm-i-74-tr11-enhancements
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.