COMMON POWERUp 2021

RPG is the best language in the world for writing business rules. But what happens when you want to use those business rules from SQL? Or from a web application that accesses your business logic through SQL? DB2 for i lets you write User Defined Functions (UDFs) in high level languages like RPG. UDFs can be called from SQL statements run from anywhere, including ad-hoc queries, SQL run from web applications, and SQL run from the embedded SQL precompilers used by RPG and other languages._x000D_ _x000D_ UDFs can even return a table (often called a UDTF, User Defined Table Function) which lets them do the same sort of work that a stored procedure would do -- but unlike stored procedures, they can return result sets to any language, including PHP, Java, .NET and embedded SQL written in ILE RPG._x000D_ _x000D_ UDFs are a powerful tool for any programmer's toolbox.

Learning Objectives:
1. Why User Defined Functions Are Useful_x000D_ 2. How to A User Defined Function in RPG_x000D_ 3. How to code a User Defined Table Function in RPG