• sales@4levels.co.za
  • +27 11 848 6229
  • 53/54, 14th Road, Noordwyk, Midrand, South Africa 1687





DB2 Web Query - Introduction to Reporting Functions

Course Description


This workshop introduces the students to DB2 Web Query capabilities and the InfoAssist report authoring tool through lecture and hands-on labs.  


This is a basic course for end users (business analysts) and I/T personnel responsible for report writing are the intended audience for the class. Application developers, database administrators, and systems administrators who plan to implement, use, or support DB2 Web Query are also encouraged to attend.


A general knowledge of IBM i concepts and DB2 for i functionality, including SQL, is of value but not a requirement.

Key topics

  • Course overview
  • Unit 1: DB2 Web Query overview Break
  • Unit 2: Building reports with InfoAssist
    • Exercise 1: InfoAssist Lab
  • Lunch
  • Unit 3: Active reports
    • Exercise 2: Active reports Break
  • Unit 4: Working with OLAP reports
    • Exercise 3: OLAP reports
  • Break
  • Unit 5: Query/400 reports
    • Exercise 4: Importing Query/400
  • Review, Q&A


  • Create reports and graphs and deploy them in PDF, Excel, Active technologies or other output options
  • Understand where to go for support
  • Articulate when you need express or standard edition of DB2 Web Query
  • Understand the options for importing Query/400 definitions

Course Duration

1 day
User Dashboard Client Zone