I am creating a new UDF (first one) and the creation is working fine (assumed) ... I get my service program created in my jasher library.
However, when I try to use the UDF, I get an error message..
Since I am NEW to the UDFs on the AS400, I am wondering if I am missing a piece. My library list includes my library, I have access to the libraries/files. I can run all this interactively on my workstation (via a Query tool) or in STRSQL and it works fine.
I cannot seem to access the UDF that was created...
ANY help will be greatly appreciated !!!
Thanks in advance.
<eb1>SQL0204 - TRANSSUM in JASHER type *N not found.
State0002,Native:-204,Origin:[IBM][iSeries Access ODBC Driver][DB2 UDB]</eb1>
Create Function jasher.transsum(intsrefn char(7), intsco integer, intscode char(2), intspn char(15), intsloct char(9)) returns integer
Reads SQL data
NO EXTERNAL ACTION
value(sum(tstqty),0) from lib1.table1 where tsco = intsco and tscode = intscode and tsloct = intsloct and tsrefn in (intsrefn,
when left(intsrefn,2) = '00' then ' '||substr(intsrefn,3)
when left(intsrefn,1) = '0' then ' '||substr(intsrefn,2)
else intsrefn end
and tspn = intspn