Can anyone show me an example of using a user defined function in SQL where the function has multiple input parameters and makes use of a program written in RPGLE?
I have created a number of SQL functions that use RPGLE programs, but the only functions that work are those with a single input parameter. The syntax I am using (and I've tried many different combinations) must be wrong, but I can't find any examples of using that type of function.
In case it helps, the multiple parameter function was defined with this piece of SQL:
and the working single parameter function used this: