DB2 Web Query: Introduction to Reporting Functions

Overview

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

Learning Journeys or Training Paths that reference this course:

Audience

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.

Prerequisites

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

Objectives

  • 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

Follow-on courses

This course is part of the Power Systems with IBM i curriculum. An additional course that may be of interest is:

     Accessing the IBM Database using SQL (OL37G)

     Developing IBM i Applications using SQL (OL38G)

     Control Language Programming Workshop for IBM i (OL20G)

Related Articles:

IBM Training Blog:

Enroll

You can enroll in an instructor-led classroom at different geographic locations, instructor-led online course in any timezone or a self-paced online course.

This class has been identified by our Global Training Partner as "Guaranteed to run". View the terms and conditions for full details.

Start Date GTR Country City Duration Language Partner Action
Botswana Gaborone, BW 8 Hours English Ingram Micro

Enroll



Skip Sign in

Angola Luanda, AO 8 Hours English Ingram Micro

Enroll



Skip Sign in

Namibia Windhoek, NA 8 Hours English Ingram Micro

Enroll



Skip Sign in

Singapore Singapore, SG 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Singapore Singapore, SG 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Indonesia Jakarta, ID 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Singapore Singapore, SG 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Kenya Nairobi, KE 8 Hours English Ingram Micro

Enroll



Skip Sign in

Zimbabwe Harare, ZW 8 Hours English Ingram Micro

Enroll



Skip Sign in

Nigeria Lagos, NG 8 Hours English Ingram Micro

Enroll



Skip Sign in

Indonesia Jakarta, ID 8 Hours English Ingram Micro/Trainocate

Enroll



Skip Sign in

Denmark København - Ballerup 8 Hours English Arrow ECS

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

India Bangalore 8 Hours English Arrow ECS/Amstar

Enroll



Skip Sign in

Switzerland Genève 8 Hours French LearnQuest/Satom IT & Learning Solutions

Enroll



Skip Sign in

Poland Warszawa 8 Hours Polish TechData Inc.

Enroll



Skip Sign in

Spain Madrid 8 Hours Spanish TechData Inc.

Enroll



Skip Sign in

United Kingdom Bracknell 8 Hours English TechData Inc.

Enroll



Skip Sign in

United Kingdom London 8 Hours English TechData Inc.

Enroll



Skip Sign in

Germany Leinfelden-Echterdingen 8 Hours German TechData Inc.

Enroll



Skip Sign in

Austria Wien 8 Hours German TechData Inc.

Enroll



Skip Sign in

Switzerland Genève 8 Hours French TechData Inc.

Enroll



Skip Sign in

Switzerland Rotkreuz 8 Hours German TechData Inc.

Enroll



Skip Sign in

Switzerland Zürich 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Switzerland Ostermundingen 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Austria Wien 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

United Kingdom London (Arrow) 8 Hours English Arrow ECS

Enroll



Skip Sign in

United Kingdom London (Arrow) 8 Hours English Arrow ECS

Enroll



Skip Sign in

Germany Düsseldorf 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Frankfurt 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Stuttgart 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany München 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

Germany Frankfurt 8 Hours German Arrow ECS/Esciris

Enroll



Skip Sign in

If you are interested in a custom or private delivery of this content, please contact a GTP about delivery in your country.

Start Date My Time Zone GTR Country Duration Language Partner Action
Worldwide8 HoursEnglishArrow ECS

Enroll



Skip Sign in

Worldwide8 HoursEnglishIngram Micro

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in

Worldwide8 HoursEnglishArrow ECS/Amstar

Enroll



Skip Sign in