×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello All,
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
UDFLIB.
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.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com <
http://www.rjssoftware.com/>
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
midrange.com
