When creating a view all unqualified specified database objects (Tables,
view, UDFs, UDTFs, global variables) are resolved depending on the naming
conventions either from the library list at creation time or the SQL Schema
(Files and Views) or SQL Path (SQL Routines, i.e. UDFs and UDTFs).
The resolved objects are included with the schema where they were found at
compile time.
So, there is no way to execute any other routine at runtime.
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)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin
Taylor
Sent: Wednesday, 8 January 2025 17:16
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: View/UDF - What library?
I've got a view that calls an external user-defined function (UDF) written
in RPGLE. The view exists in multiple libraries, so the UDF needs to know
which library it is in.
Is there a way in the DDL for the view to determine what library it is in?
If so, I could simply pass it to the UDF as a parameter.
Is there a way in the UDF to determine the library of the calling view?
Thanks
--
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.
midrange.com
