Re: creating table function - UDTF and then calling -- MIDRANGE-L

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

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/25/2018
09:43:07 AM:

when calling , get 4 message in log

SQL0204 LOCATIONS_BY_FUND_MEMBER in QSYS type *lib not found
Diagnostic

CPF503E user defined function error on member
QSQPTABL Notify

CPF503E user defined function error on member
QSQPTABL Senders Copy

SQL0204 LOCATIONS_BY_FUND_MEMBER in QSYS type *lib not found
Diagnostic

even though it says it's not found, it found it and returned an empty

table

(with column headings)

Is there an issue with SQL only table function?
Is this a 10 character limit on function name?
Something else?

Even though you are qualifying the function name, since it is
being called from off-platform so you need to make sure the caller is
using "naming=system" in the connection string for the session. The
default is "naming=sql" and that causes the default schema to be equal to
the user name also specified in the credentials for the connection string.
Using "naming=system" will allow the session to have access to the full
library list associated.

Sincerely,

Dave Clark

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.