Skip to main content

   

IBM Redbooks  >  IBM System i




Redbooks Abstract

Getting Started with DB2 Web Query for System i



Download PDF (8.2 MB)


Get Adobe® Reader®


Additional Material


View as HTML


Tips for viewing


Discuss this book (0)


Order Hardcopy


Others who downloaded this book also downloaded ...

Abstract

The DB2® Web Query for System i™ product is a Web-based query and report writing product that offers enhanced capabilities over the IBM® Query for iSeries® (also commonly known as Query/400) product. IBM DB2 Web Query for System 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 Report Assistant, Graph Assistant, and Power Painter. Using these tools, customers can modernize existing Query for iSeries reports while providing a foundation for building more complex business intelligence applications, such as online analytical processing (OLAP), data mining, dash boarding, or data warehouse implementations.

This IBM Redbook publication gives a broad understanding of the new DB2 Web Query product. It entails a group of self-explanatory tutorials to help you get up to speed quickly. Overall this book is designed for IT users. You can extract and use Part 2, "Tutorials for DB2 Web Query," and Part 3, "Tutorials for DB2 Web Query optional features," as stand-alone tutorials for anyone who is developing their own queries. Much of Chapter 8, "Active Reports," is appropriate for those who work disconnected from the System i environment. In addition, you can use much of Chapter 10, "Online analytical processing," if you will simply be running OLAP-enabled reports.

Table of Contents

Part 1. Background, installation, and setup
Chapter 1. Product architecture and overview
Chapter 2. Installation and server operations
Chapter 3. DB2 Web Query fundamentals
Part 2. Tutorials for DB2 Web Query
Chapter 4. Getting started with the tutorials
Chapter 5. Report Assistant
Chapter 6. Graph Assistant
Chapter 7. Power Painter
Part 3. Tutorials for DB2 Web Query optional features
Chapter 8. Active Reports
Chapter 9. Developer Workbench
Chapter 10. Online analytical processing
Chapter 11. HTML Layout Painter
Chapter 12. Additional features of Developer Workbench
Part 4. Miscellaneous or additional topics
Chapter 13. Using DB2 Web Query to run existing Query/400 reports
Chapter 14. Performance considerations
Chapter 15. Frequently Asked Questions
Appendix A. Metadata in the integrated file system
Appendix B. Date and time functionality
Appendix C. Processing differences between the define and compute fields
Appendix D. Setting up DB2 Web Query to run in an IASP environment
Appendix E. Additional material

Others who downloaded this publication also downloaded
IBM i5/OS Program Conversion: Getting Ready for i5/OS V6R1, REDP-4293-00
IBM System i Overview: Models 515, 525, 550, 570, 595, and More, REDP-5052-00
Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries, SG24-6503-02


Profile

Publish Date
15 November 2007

Rating: rating
(based on 5 reviews)

Rate this book

Author(s)
Hernando Bedoya
Jackie Jansen
Gene Cobb
Renee Mason

Contributing Companies
Information Builders

ISBN
0738486760

IBM Form Number
SG24-7214-00

Number of pages
410