Re: View/UDF - What library?

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

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)