IBM DB2 Web Query for System i Overview

 

IBM^® DB2^® Web Query for System i™ is a complete, web-ready data access and reporting system, which takes advantage of the low-cost, low-maintenance, and wide distribution capabilities of the world wide web and internal corporate web sites. This system also provides a streamlined reporting environment that virtually eliminates the complexities of today's corporate data.

• Printable PDF
  Use this to view and print a PDF of this information.

• Introducing IBM DB2 Web Query for System i
  Provides an overview of IBM DB2 Web Query for System i and describes the end-user components and tools you use to run, view, create, and edit reports.

• Using the Reporting Interface
  Describes the reporting interface for IBM DB2 Web Query for System i, which you can use to select a domain, use items (reports, graphs, URLs) in the Domain Tree, search domains, access reporting tools such as Power Painter, Report Assistant, and Graph Assistant, and much more.

• Using Power Painter
  Describes how to use the Power Painter to create reports, graphs, and page layouts.

• Creating a Report With Report Assistant
  Describes how to use the HTML Report Assistant to create tabular reports.

• Analyzing Data in an OLAP Report
  Presents the terminology and benefits of using Online Analytical Processing (OLAP). Describes how to customize reports with the OLAP selections panel and the OLAP Control Panel. Describes how to sort and apply various selection criteria (to restrict your data) as well as how to troubleshoot an OLAP-enabled report. Explains how the OLAP Control Panel (OCP) provides you with a versatile way to gain more insight from your reports by dynamically manipulating report data. From the Control Panel, you can perform every function available to a DB2 Web Query OLAP user.

• Creating a Graph With Graph Assistant
  Describes how to use the HTML Graph Assistant to create graphical reports.

• Visualizing Trends in Reports
  Describes how to insert visual representations (in the form of bar graphs) of selected data directly into your report output.

• Using the DB2 Web Query Viewer
  Describes how to use the DB2 Web Query Viewer to view long reports.

• Understanding User Interface Basics
  Introduces user interface design in DB2 Web Query and describes the components of a typical user interface.

• Creating a Reporting Procedure With SQL Report Wizard
  Describes how to use the SQL Report Wizard.

• Designing a User Interface for a Web Application With the HTML Layout Painter
  Describes how to create a user interface in the local development environment using the HTML Layout Painter.

• Describing and Accessing Data: Overview
  Introduces data source descriptions and explains how to use them.

• Using the Synonym Editor
  Describes the Synonym Editor and how you may use it to view and edit synonyms.

• Analyzing Metadata and Procedures
  Describes how to analyze procedures using Impact Analysis, and how to view Data Profiling for the columns in a synonym.

• Running Web Query Reports Using the Java Batch Run Utility
  Describes how to run Web Query Reports using the Java™ Batch Run Utility.