Date & Time
Wednesday, October 19, 2022, 5:00 PM - 9:00 PM EDT
About Event
Join us for an informative session with Gregory Simmons, a software engineer at PC Richard & Son. The pre-session will focus on improving RPG program performance through dataset processing. The main session will cover techniques for embedding SQL into legacy RPG code, including starting with simple programs, handling multi-member files, and converting DDS described files to SQL tables. Enhance your skills in modernizing legacy code for better performance and maintainability.
Schedule
Pre-Session
Moving to Dataset Processing
Networking & Cocktail Hour
Connect and enjoy our open bar.
Dinner & Q&A
Interactive session over dinner.
Main Session
Embedding SQL into Legacy Code
Session Ends
Wrapping up with gratitude
What Will You Learn?
Dataset Processing
Explore three approaches to improving RPG program performance by reducing I/O counts through dataset processing.
Embedding SQL
Discover methods for embedding SQL into legacy RPG code to enhance performance and maintainability.
SQL Conversion
Learn how to convert DDS described files to SQL tables using the surrogate logical method.
Keynote Speaker
Gregory Simmons
Project Manager at P.C. Richard & Son
Gregory Simmons is a Project Manager with P.C. Richard & Son. He started on the IBM i platform in 1994, graduated with a degree in Computer Information Systems in 1997, and has been working on the i ever since. He has been a registered instructor with the IBM Power Schools Academy since 2007, holds a COMMON Application Developer certification, IBM Champion, a member of the CAAC and is a contributing author at ITJungle.com.