Back To Schedule
Tuesday, October 5 • 1:30pm - 2:30pm
RPG User Defined Functions & Table Functions

Log in to save this to your schedule, view media, leave feedback and see who's attending!

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

avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 2 Online

Attendees (1)