Calling SQL Functions From RPG, A Service Program
November 15, 2016 Paul Tuohy
Note: The code accompanying this article is available for download here.
In this article I would like to introduce a service program that provides RPG subprocedure “wrappers” for using SQL scalar functions. This means you can use an SQL scalar function as if it were an RPG built-in function.
Using an SQL scalar function can be a lot easier than using the RPG alternative: