We created an SQL user defined function in a service program for use
within our application code. As an example let's say the service program is called UDFRPG and the
function is called UDF1. UDFRPG containing UDF1 is located in library
When I use the UDF I normally specify it as such:
SELECT * FROM LIB/FILE WHERE UDF1() = 1
If the UDFRPG library is in my library list, SQL finds UDFRPG/UDF1 just
fine. If not, the SQL processor tells me UDF1 was not found. Now the question:
Is there a way to qualify a call to a SQL UDF so that it does not need
to be in the library list of the calling job ?
I wanted to ask here before I invested time researching since someone
here has undoubtedly come across the same issue. **Note: The job is running from a Java process that uses JDBC/JT400. I
know I can affect the library list with the JDBC property called:
"libraries", but I was curious on the qualification of UDF calls because
we don't want to hard set libraries in the JDBC properties settings.
Any thoughts would be appreciated.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact