Re: udf with imbedded SQL

["Richard Theis" <theis_richard@xxxxxxxxxx>]

> drop function FAXNEWAREA

> create function FAXNEWAREA (CHAR (3), CHAR (3))
> returns CHAR (3)
> simple call
> language rpgle
> deterministic
> reads sql data
> returns null on null input
> no external action
> allow parallel
> external name 'ROUTINES/SRVPGM(FAXNEWAREA)'

Rob,
It looks like a  *LIBL problem.
When issuing the above statements, which naming are you using (*SYS or
*SQL) ?  I suspect the latter.
BTW, look at SYSFUNCS and check the ROUTINE_SCHEMA value for FAXNEWAREA:
it's the library name your UDF is catalogued.  In order to use the UDF,
this library has to be in your *LIBL, in *SYS naming.  In *SQL naming, you
can use THIS_LIBRARY.FAXNEWAREA syntax in the SELECT statement (but it's
cumbersome), or issue the SET PATH statement before, like SET PATH SYSTEM
PATH THIS_LIBRARY  (SYSTEM PATH represents QSYS QSYS2).
HTH
Best regards
Richard THEIS
  AS/400 Education, France
  theis_richard@fr.ibm.com