LISUG Logo

  • Home

  • Event Showcase

  • Contact

  • Membership

  • Board Members

  • About Us

LISUG Logo

Navigation

  • Home
  • Featured Event
  • Contact
  • Membership
  • Board Members
  • About Us

About LISUG

  • Newsrooms
  • Volunteer
  • Support
  • Donate

Reach Us

  • Contact Page
  • support@lisug.org

Join our newsletter

Get the latest news and updates from LISUG straight to your inbox.

Follow us:

© 2026 LISUG. All Rights Reserved.

Optimizing RPG Programs with Gregory Simmons

Enhancing Legacy Code with SQL

Enhance your RPG programs and modernize legacy code with insights from Gregory Simmons. Learn about dataset processing and embedding SQL for improved performance.

Date & Time

Wednesday, October 19, 2022, 5:00 PM - 9:00 PM EDT

Venue

Westbury Manor

1100 Jericho Turnpike

Westbury

NY - 11590

Event Completed!

0

DAYS

0

HOURS

0

MINUTES

0

SECONDS

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

5:00 PM

Networking & Cocktail Hour

Connect and enjoy our open bar.

6:00 PM

Dinner & Q&A

Interactive session over dinner.

7:00 PM

Main Session

Embedding SQL into Legacy Code

8:00 PM

Session Ends

Wrapping up with gratitude

9:00 PM

Keynote Speaker

Gregory Simmons Image

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.

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.