The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Thursday, April 27 • 10:30am - 11:30am
135: Expand Your Options using Query Management

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Query Management may be one of the better-kept secrets on IBM i. It has been part of the operating system since version 3.0 of OS/400. Yet developers don't seem to know it exists, or what it can do for them. Query management objects give the IBM i developer the means to use the full power of SQL without having to purchase the SQL licensed product. It also provides reporting capabilities similar to those of Query for i, with some things that Query for i can't begin to do. Query Management (QM) objects can also be used with programs and commands to provide parameterized reporting and data presentation.

Learning Objectives:
1. Use CL commands to create Query Management objects
2. Use Query Manager to work with Query Management objects
3. Create commands that use Query Management objects

avatar for Vern Hamberg

Vern Hamberg

Senior IT Developer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior IT developer for the Pest Elimination division at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

Thursday April 27, 2023 10:30am - 11:30am MDT
Plaza Court 5
  • Session Level Beginner
  • Audience Developers who need to quickly generate reports and may not want to write programs to do it, who want to enhance their ability to deliver data-centric information in their enterprise.