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.

This documentation provides an overview of IBM DB2 Web Query for System i. It also describes the components and tools you use to run, view, create, and edit reports. Use this documentation to learn about the structure and the capabilities of each component and tool.

 

Parent topic:

IBM DB2 Web Query for System i Overview

 

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.

 

Reporting Concepts

The reporting environment includes Domains which are the highest level of organization. Domains provide data on a particular topic (such as sales, inventory, or finance). The data is stored in different forms in the following domain tree components: Reports and Other Files. The Other Files folder, available to Administrators and Developers, can contain images (.gif, .jpg), HTML files, and other files that you can use to customize and enhance reports.

 

Reporting Features

A selection of reporting tools is available for you to create and edit reports, manipulate data in an existing report, and view a report.

Power Painter. Power Painter is a Web layout and report creation tool that enables you to create output and page layout formats. It combines reporting, graphs, and page layout design in a single tool.

Report Assistant. Report Assistant is an HTML-based tool that you use to create tabular reports. From Report Assistant you select the data that constitute your report, create new data from existing data, apply screening conditions to the data, as well as format and style your report.

Graph Assistant. The Graph Assistant is an HTML-based tool that guides you step-by-step through the creation of a graph. The Graph Assistant enables you to create and style your graphs.

 

Reporting Interface

The reporting interface is ideal for users who quickly need to run reports. Check your installation manual for information about browser compatibility. This interface offers you the ability to access reporting tools such as Power Painter, Report Assistant, and Graph Assistant.

The reporting interface is an HTML-based front-end that allows you to:

 

Development Environment

The DB2 Web Query Developer Workbench product is an optional add-on Windows-based development environment for creating applications. Developer Workbench provides intuitive GUI tools that free developers from the hassles of coding, thereby allowing them to concentrate on interface design, business logic, and data manipulation. Using Developer Workbench, developers can build powerful Web page interfaces that allow users to run customized reports.