Re: View/UDF - What library?

Instead of using a UDF can you use a UDTF? Just check at the start with
the UDTF

On Wed, Jan 8, 2025 at 4:01 PM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

That works. This and Rob's checking for locks take about 0.15 seconds.
I'm reluctant to put either in the UDF, since that adds 0.15 seconds per
row. I'm trying to come up with some way to only check once per query.
Hmm...


Thanks


date: Wed, 8 Jan 2025 19:44:34 +0100

from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: RE: View/UDF - What library?

If you want to check the library list, where a specific view is found,

you

can run the following query:

Select a.Schema_Name
from Library_List_Info a join SysTables b on Schema_Name = Table_Schema
Where Table_Type = 'V'
and Table_Name = 'YOURVIEWNAME'
Order By Ordinal_Position
Limit 1;

Mit freundlichen Gr??en / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"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)
"Learning is experience ? everything else is only information!" (Albert
Einstein)

--
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.