Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Wednesday, May 22 • 5:15pm - 6:15pm
48CE OPEN LAB: Expand Your Options Using Query Management

Log in to save this to your schedule and see who's attending!

Tweet Share
Feedback Survey
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 a command to execute SQL statements from a command line
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior IT Developer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 25 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 →

Wednesday May 22, 2019 5:15pm - 6:15pm
Fantasy Tower Castle A-C
  Database
  • 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.

Twitter Feed