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

• 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 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.

• 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

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf
Once you enroll in a GTP class, you will receive a confirmation letter that should show:
    The current GTP list price
    The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.