Back To Schedule
Monday, September 14 • 10:00am - 10:55am
OPEN LAB: 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.
1. Use CL commands to create Query Management objects 2. Use Query Manager to work with Query Management objects 3. Create a command to execute SQL statements from a command line

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 →

Monday September 14, 2020 10:00am - 10:55am CDT
Lab Room 2