Stored Procedures for Hybrid Development

About the Webinar

Sharing IBM i business logic across systems has become both a necessity and a challenge as businesses increasingly opt for hybrid development. Traditionally embedded within RPG programs, this logic often needs to be replicated across multiple application layers to enable access across open-source and off-platform applications. This approach leads to duplicated logic, version inconsistencies, and change-management challenges, ultimately increasing maintenance effort, security risks, and modernization complexity.

In this webinar, IBM Champion Mike Pavlak will explore how centralizing business logic within the database using Db2 stored procedures can address these challenges. Tailored for developers with more than one year of experience, this session will demonstrate how to create and execute RPG and SQL stored procedures on IBM i, encapsulating core logic at the database level to establish a single, reusable source of truth.

Additionally, attendees will also see practical examples of how Db2 stored procedures can be called from open-source languages such as PHP and Python, enabling true hybrid development without compromising existing IBM i investments.

Key Takeaways:

• Enable easier and more secure access to IBM i business logic through live demonstrations of creating and executing RPG and SQL stored procedures
• Foster hybrid development with real-world examples of consuming Db2 stored procedures from open-source languages like Python and PHP
• Enhance stored procedure effectiveness using expert-recommended tools, techniques, and best practices