COMMON POWERUp 2021

IBM i services are SQL interfaces into systems information. They are GREAT, but they are plumbing, and you still need to build something around them to simplify the value of them. Perhaps you want to see the data in spreadsheets or chart representation, or email important utilization trend reports to stake holders. Web Query can provide the SOLUTION around the plumbing EASILY with new features like "EZ-Report." This session will show you how, including how to get Spooled File data into a spreadsheet or PDF with ease.

Learning Objectives:
1. Learn how Db2 Web Query can leverage SQL specific to IBM i Services_x000D_ 2. Learn how to handle different delivery options of IBM i Services (views, UDTFs, procedures)_x000D_ 3. Learn how to enable services for reports that consolidate data from multiple systems/LPARs.