This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | OD040 | Skill level | Basic |
|---|---|---|---|
| Duration | 1.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $800.00 plus tax | ||
Hands on labs will teach you to use the highly productive DB2 Web Query Report Assistant and Graph Assistant to produce web based reports and graphs. Learn how to create selective reports/graphs with parameters and drill down function. You'll also learn how easy it is to direct your output to a PDF, to automatically produce an Excel spreadsheet or to direct your output to one of thirteen other formats. Hand-on labs will teach you how to easily convert and extend your Query for iSeries Reports into browser based DB2 Web Query Reports. You'll extend those Query reports with traffic lighting, you'll also direct output to Microsoft Excel and take the quieries to a whole new level with Active Reports. You'll see demonstrations of Executive Dashboards and Key Performance Indicator (KPI) Reports that could be created with additional DB2 Web Query components. Optionally you can learn how install DB2 Web Query on your IBM i.
DB2 Web Query for Users, Developers and Administrators (ODO50) is an alternate class that not only teaches basic function with hands on labs, but also teaches how to use and develop Online Analytical Processing (OLAP) function, Dashboards, KPIs and to extend DB2 Web Query performance and security with advanced IBM i and IBM i DB2 functions.
View this course in other countries
Training Paths that reference this course are:
Audience
This is a basic course for end users, programmers, department heads who need to analyze the data in their environment and want to turn it into a business asset.
Skills taught
After completing this course, you should know how to:
- Learn how to replace Query for iSeries 5722-QU1 with DB2 WebQuery for i5/OS 5733-QU2
Course outline
- DB2 Web Query Overview
- Report Assistant and Active Reports
- Converting Existing Query Reports
- Graph Assistant
- Optional: Installation and Management
- Next Steps
- Q and A
Remarks
Special Note for IBM Business Partners authorized to remarket IBM IT Education Services public classes and on-site classes: This course is excluded from the IBM Technical Training Services for Public Education Program and the IBM Training Services for Enterprise - on-site Education Program for IBM Business Partners.
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
