creating table function - UDTF and then calling

one of our java developers (on a non-I system) wants to create a table
function to call - it creates but does not execute and the messaging is
confusing (to me)

Create statement (partial - it's big

CREATE OR REPLACE FUNCTION KRMDATA.LOCATIONS_BY_FUND_MEMBER(EMFND#
DECIMAL(3,0), EMMEMB DECIMAL(5,0))

RETURNS TABLE (EMPSPL CHAR(30), EMFDYR DECIMAL(4,0), EMFND# DECIMAL(3,0),
EMMEMB DECIMAL(5,0), EMMSUB DECIMAL(2,0), EMNAME CHAR(30), EMFDID
DECIMAL(9,0), LOCATION_# CHAR(30)

LANGUAGE SQL

READS SQL DATA

NO EXTERNAL ACTION

DETERMINISTIC

RETURN

SELECT EM.EMPSPL ,EM.EMFDYR ,EM.EMFND# .... much more


calling from V7R1 i Navigator
calling - select * from TABLE(KRMDATA.LOCATIONS_BY_FUND_MEMBER(730,87)) ASC

(the ASC - syntax checker was requiring "something " there


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?

Jim Franz