Case Studies in Embedding SQL into Legacy RPG Programs - Gregory Simmons

Code Monkeys unite! I've been monkeying with code for the better part of 25 years now and if you’re like me, most of your days aren't spent on new development, but rather on code that may, in some cases, be older than you are! While some of this code is old, that doesn't mean necessarily that it doesn't work. Far from it, this old code has been contributing day in and day out to the success and growth of my company. Sound familiar? This session is a compilation of lessons learned while breathing life into legacy code. Come join us to learn handy, time-saving tools to adding the latest in IBM i technologies to your own code base!

Learning Objectives:

Explore easy ways to breath some fresh air into legacy code.
Tips and techniques for dealing with multi-member physical files while converting RPG code to SQLRPGLE code.
What to watch out for when doing code conversion.
Watch out for potential degradation of performance, but also watch for potential boosts in performance.

Gregory Simmons

Software Engineer, Jack Henry & Associates

Gregory Simmons is a Senior Application Developer at Jack Henry and Associates, where he contributes to new and existing banking and financial software products for midsize local and regional banks. He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where he focuses on enlightening the next generation of IBM i programmers.

Simmons currently serves as Scoutmaster of his son’s local Boy Scout Troop. He enjoys camping, fishing, backpacking, running, scuba diving, and working with others to try new things outside of their comfort zones.