Re: SQL UDF to call RPG without service program

Vern,

You can get something back from stored procs or functions.

Functions can only return 1 piece of data (could be an array now-a-days) ,
stored procs can have multiple output (or IN/OUT) parms.

Just like an RPG Program, an SQL stored proc usually does some
significant chunk of work. Whereas a a SQL function or RPG Procedure tends
to do some smaller (usually repeated) work.

Repeated invocation is the point for UDFs, as shown in Roberts example:
SELECT
ivwhid AS "Warehouse",
ivitm# AS "Item Number",
GETUPCHARGEFUNC(ivwhid, ivitm#) AS "Up Charge"
FROM invmasp
WHERE ivwhid = 90
AND ivitm# = 5
ORDER BY 1, 2;

Charles