Re: Create UDF for SQL function

[John Rusling <jrusling@xxxxxxxxxxxxxxxxxxx>]

I had problems, similar, a month or so ago.

I changed the external name to all uppercase, instead of matching
the case of the procedure, and it works, and is working.

<g> Which goes against everything I've read on this.

John B.

CREATE FUNCTION qgpl/CvtUsaToCyymmdd(                    
       pInput varchar(30)
       )                                         
  RETURNS DEC(7,0)                               
  LANGUAGE RPGLE                                 
  NOT DETERMINISTIC                              
  NO SQL                                         
  RETURNS NULL ON NULL INPUT                     
  EXTERNAL NAME 'WZZZJBL0/S_DTTM_F(DTTM_CVTUSATOCYYMMDD)'
  PARAMETER STYLE GENERAL                        


> Create Function FmtName (slsnnm char (30) ) 
>               returns char(30) 
>                language rpgle 
>                deterministic 
>                no sql 
>                external name 'JJKLIB/GETNAME(FmtName) ' 
>                parameter style general