Duration

1 day

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:

Application Developer using RPG IV
End User
Application Developer using SQL
End User

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.

Course overview

Exercise 1: InfoAssist Lab
Lunch
Exercise 2: Active reports Break
Exercise 3: OLAP reports
Break
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

This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.