May 2017
Intermediate to advanced
212 pages
5h 45m
English
book
IBM DB2 Web Query for i: The Nuts and Bolts
by Hernando Bedoya, Jim Bainbridge, Rob Bestgen, Mike Cain, Doug Mack, Simona Pacchiarini, Kathryn Steinbrink, Lin Su, Kevin Trisko
Overview
Abstract
Business Intelligence (BI) is a broad term that relates to applications that analyze data to understand and act on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the user.
At the core of any BI solution are user query and reporting tools that provide intuitive access to data supporting a spectrum of users from executives to “power users,” from spreadsheet aficionados to the external Internet consumer.
IBM® DB2® Web Query for i offers a set of modernized tools for a more robust, extensible, and productive reporting solution than the popular IBM Query for System i® tool (also known as IBM Query/400). IBM DB2 Web Query for i preserves investments in the reports that are developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. But, it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.
The DB2 Web Query for i product is a web-based query and report writing product that offers enhanced capabilities over the IBM Query for iSeries product (also commonly known as Query/400). IBM DB2 Web Query for i includes Query for iSeries technology to assist customers in their transition to DB2 Web Query. It offers a more modernized, Java based solution for a more robust, extensible, and productive reporting solution.
DB2 Web Query provides the ability to query or build reports
against data that is stored in DB2 for i (or Microsoft SQL Server)
databases through browser-based user interface
technologies:
Build reports with ease through the web-based, ribbon-like
InfoAssist tool that leverages a common look and feel that can
extend the number of personnel that can generate their own
reports.
Simplify the management of reports by significantly reducing the
number of report definitions that are required through the use of
parameter driven reports.
Deliver data to users in many different formats, including
directly into spreadsheets, or in boardroom-quality PDF format, or
viewed from the browser in HTML.
Leverage advanced reporting functions, such as matrix reporting,
ranking, color coding, drill-down, and font customization to
enhance the visualization of DB2 data.
DB2 Web Query offers features to import Query/400 definitions and
enhance their look and functions. By using it, you can add
OLAP-like slicing and dicing to the reports or view reports in
disconnected mode for users on the go.
This IBM Redbooks® publication provides a broad understanding of what can be done with the DB2 Web Query product. This publication is a companion of DB2 Web Query Tutorials, SG24-8378, which has a group of self-explanatory tutorials to help you get up to speed quickly.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.