Re: SQL UDF From RPG Program

The concept is called "overloading". You can have the exact same UDF
name, with different parameters, parameter sizes, even decimal versus
character, etc. Then it could call a different RPG subprocedure based on
that.
CREATE FUNCTION DMIPGMS/GETZIPDIST ( CHAR(5), CHAR(5) )
RETURNS DOUBLE
...
EXTERNAL NAME 'DMIPGMS/SQLGETZIPD';


CREATE FUNCTION DMIPGMS/GETZIPDIST ( CHAR(5), DEC(9 0) )
RETURNS DOUBLE
...
EXTERNAL NAME 'DMIPGMS/SQLGETZCD'; // Notice different?


Rob Berendt