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.

Mastering IBM i Services (SQL)

Enhancing System Administration with SQL

Elevate your IBM i system administration skills with SQL insights from Steve Riedmueller. Learn to tackle real-world problems and automate tasks using powerful SQL tools in both introductory and advanced sessions.

Event Date

September 11, 2024

Time

5:00 PM - 9:00 PM

Venue

Rosemarie's Pizzeria & Restaurant

188 Merritts Rd

Farmingdale

NY - 11735

Event Completed!

0

DAYS

0

HOURS

0

MINUTES

0

SECONDS

About Event

Join us for an in-depth learning experience with Steve Riedmueller, a seasoned expert in IBM i system administration. This event features two sessions designed to equip system administrators with practical SQL skills to solve real-world problems and enhance system management.

The introductory session, "Intro to IBM i Services (SQL) for Admins," is perfect for traditional "green screen" administrators who want to start leveraging SQL. It covers how to use the “Run SQL Scripts” tool to investigate active, queued, and completed jobs, retrieve system networking information, investigate object locks, and more. Don’t be intimidated by SQL; it’s a powerful tool that you can easily start using with the examples provided.

The advanced session, "Advanced IBM i Services (SQL) for Admins," builds on the introductory session and dives deeper into the capabilities of IBM i Services. You’ll learn how to join data from multiple IBM i Services to create "SuperTools," use the QCMDEXC() scalar function, and create your own User Defined Functions (UDFs). This session is ideal for administrators with some SQL experience who want to take their skills to the next level.

Schedule

Intro to IBM i Services (SQL)

Learn to solve real-world system admin problems using SQL and IBM i Services.

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

Advanced IBM i Services (SQL)

Dive deeper into IBM i Services with advanced techniques for monitoring, automation, and custom tools creation.

8:00 PM

Session Ends

Wrapping up with gratitude

9:00 PM

Keynote Speaker

Steve Riedmueller Image

Steve Riedmueller

IBM i (AS400) Tech Lead at Wiley

Steve has been working on the IBM i platform in a System Administration/Engineering role since 2001. He has developed an expertise in system security, performance, communications, and various IBM and 3rd-party software packages including WAS, MQ, Apache, OnDemand, LANSA, Zend, Synon, and more. Steve holds a B.S. from Rutgers University. In recent years Steve has become a COMMON and WMCPA speaker, an N2i mentor, and taken a leadership role in the N2i committee. In the world of IBM i technology, Steve is passionate about process improvement. He enjoys leveraging IBM i SQL Services for administration/operations tasks such as security and performance, as well as automation. In his free time Steve enjoys StarCraft 2, weight lifting, and RVing.

What Will You Learn?

Intro to IBM i Services (SQL)

Learn how to use SQL to solve real-world system admin problems, investigate jobs, retrieve networking information, and more with practical examples.

Advanced IBM i Services (SQL)

Explore advanced use cases for IBM i Services, including joining data to create "SuperTools," using the QCMDEXC() function, and creating User Defined Functions (UDFs).

Enhanced SQL Skills

Develop your SQL skills to monitor systems, automate tasks, and efficiently manage IBM i environments, moving beyond basic queries to more complex solutions.