IBM DB2 Web Query for System i Powered by WebFOCUS

IBM is replacing Query for iSeries (previously Query/400) with IBM DB2 Web Query for System i. This product – powered by Information Builders – contains a subset of WebFOCUS features with additional capabilities available as options from either IBM or from Information Builders.

Web Query Product Functionality

DB2 Web Query is an effective tool for delivering queries, production reports, and dashboard-like compound reports. It delivers almost complete translation of Query 400 queries into WebFOCUS reports with full support for any computations, functions, aggregation, and formatting options such as headings, column titles, footings, and subtotals. DB2 Web Query also supports batch execution and printing of reports on System i.

End users can run pre-defined reports, and any user can be designated as a developer. Each class of IBM System i servers will have between 2 to 20 named users to start, and IBM will be ability to increase the number of users.

    IBM Base Product Set

    DB2 Web Query for System i includes a WebFOCUS reporting server running in i5/OS, a simplified static dashboard user interface, and:

  • DB2 adapter (on System i only)
  • DBFILE adapter (System i and multiple member files)
  • Query 400 query adapter (for translating Q400 queries)

Web Query Product Sales

The Web Query product is sold and distributed by IBM and its reseller partners. Information Builders will not be selling this product. IBM customers who currently are have a software maintenance with the Query/400 (QU1) product will receive the base product set listed above, as will customers who purchase a new i5 Server or upgrade to an existing server.

Learn More