POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Monday, May 20 • 9:15am - 10:15am
22AL Expand Your Options Using Query Management

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 is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →

Monday May 20, 2019 9:15am - 10:15am PDT
Fantasy Tower North Ballroom A
  • Level All
  • Operating System IBM i
  • 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.