LISUG Logo

  • Home

  • Event Showcase

  • Membership

  • Board Members

  • About Us

LISUG Logo

Navigation

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

About LISUG

  • Newsrooms
  • Volunteer
  • Support
  • Donate

Join our newsletter

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

Follow us:

© 2025 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.

Event Date

October 19, 2022

Time

5:00 PM - 9:00 PM

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

Software Engineer | Project Manager at PC Richard & Son

Gregory Simmons is a seasoned Software Engineer and Project Manager at PC Richard & Son, with over 25 years of experience in software development. Known for his expertise in multiple programming languages and platforms, Gregory is dedicated to writing efficient and fast code. Before joining PC Richard & Son, he spent 25 years at Jack Henry & Associates, refining his skills in application development. Gregory also served as a Technical Engineering Specialist in the Army National Guard and is a passionate educator, teaching AS/400 systems and RPG programming. His extensive experience and commitment to continuous learning make Gregory a respected expert in modern web app development and IBM i environments.

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.