IBM DB2 Web Query for i: The Nuts and Bolts

IBM DB2 Web Query for i: The Nuts and Bolts

Author: Hernando Bedoya

Publisher: IBM Redbooks

Published: 2017-05-11

Total Pages: 228

ISBN-13: 0738442488

DOWNLOAD EBOOK

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.


Book Synopsis IBM DB2 Web Query for i: The Nuts and Bolts by : Hernando Bedoya

Download or read book IBM DB2 Web Query for i: The Nuts and Bolts written by Hernando Bedoya and published by IBM Redbooks. This book was released on 2017-05-11 with total page 228 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.


IBM DB2 Web Query for i

IBM DB2 Web Query for i

Author: Hernando Bedoya

Publisher:

Published: 2017

Total Pages:

ISBN-13:

DOWNLOAD EBOOK


Book Synopsis IBM DB2 Web Query for i by : Hernando Bedoya

Download or read book IBM DB2 Web Query for i written by Hernando Bedoya and published by . This book was released on 2017 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt:


Getting Started With DB2 Web Query for i

Getting Started With DB2 Web Query for i

Author:

Publisher:

Published: 2010

Total Pages: 596

ISBN-13:

DOWNLOAD EBOOK


Book Synopsis Getting Started With DB2 Web Query for i by :

Download or read book Getting Started With DB2 Web Query for i written by and published by . This book was released on 2010 with total page 596 pages. Available in PDF, EPUB and Kindle. Book excerpt:


IBM i 7.2 Technical Overview with Technology Refresh Updates

IBM i 7.2 Technical Overview with Technology Refresh Updates

Author: Ryan Cooper

Publisher: IBM Redbooks

Published: 2016-11-02

Total Pages: 520

ISBN-13: 0738442070

DOWNLOAD EBOOK

This IBM® Redbooks® publication provides a technical overview of the features, functions, and enhancements that are available in IBM i 7.2, including all the available Technology Refresh (TR) levels, from TR1 to TR3. This publication provides a summary and brief explanation of the many capabilities and functions in the operating system. It also describes many of the licensed programs and application development tools that are associated with IBM i. The information that is provided in this book is useful for clients, IBM Business Partners, and IBM service professionals that are involved with planning, supporting, upgrading, and implementing IBM i 7.2 solutions.


Book Synopsis IBM i 7.2 Technical Overview with Technology Refresh Updates by : Ryan Cooper

Download or read book IBM i 7.2 Technical Overview with Technology Refresh Updates written by Ryan Cooper and published by IBM Redbooks. This book was released on 2016-11-02 with total page 520 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication provides a technical overview of the features, functions, and enhancements that are available in IBM i 7.2, including all the available Technology Refresh (TR) levels, from TR1 to TR3. This publication provides a summary and brief explanation of the many capabilities and functions in the operating system. It also describes many of the licensed programs and application development tools that are associated with IBM i. The information that is provided in this book is useful for clients, IBM Business Partners, and IBM service professionals that are involved with planning, supporting, upgrading, and implementing IBM i 7.2 solutions.


Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between

Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between

Author: Nadir K. Amra

Publisher: IBM Redbooks

Published: 2015-12-07

Total Pages: 712

ISBN-13: 073843986X

DOWNLOAD EBOOK

This IBM® Redbooks® publication is focused on melding industry preferred practices with the unique needs of the IBM i community and providing a holistic view of modernization. This book covers key trends for application structure, user interface, data access, and the database. Modernization is a broad term when applied to applications. It is more than a single event. It is a sequence of actions. But even more, it is a process of rethinking how to approach the creation and maintenance of applications. There are tangible deliveries when it comes to modernization, the most notable being a modern user interface (UI), such as a web browser or being able to access applications from a mobile device. The UI, however, is only the beginning. There are many more aspects to modernization. Using modern tools and methodologies can significantly improve productivity and reduce long-term cost while positioning applications for the next decade. It is time to put the past away. Tools and methodologies have undergone significant transformation, improving functionality, usability, and productivity. This is true of the plethora of IBM tools and the wealth of tools available from many Independent Solution Providers (ISVs). This publication is the result of work that was done by IBM, industry experts, and by representatives from many of the ISV Tool Providers. Some of their tools are referenced in the book. In addition to reviewing technologies based on context, there is an explanation of why modernization is important and a description of the business benefits of investing in modernization. This critical information is key for line-of-business executives who want to understand the benefits of a modernization project. This book is appropriate for CIOs, architects, developers, and business leaders. Related information Making the Case for Modernization, IBM Systems Magazine


Book Synopsis Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between by : Nadir K. Amra

Download or read book Modernizing IBM i Applications from the Database up to the User Interface and Everything in Between written by Nadir K. Amra and published by IBM Redbooks. This book was released on 2015-12-07 with total page 712 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication is focused on melding industry preferred practices with the unique needs of the IBM i community and providing a holistic view of modernization. This book covers key trends for application structure, user interface, data access, and the database. Modernization is a broad term when applied to applications. It is more than a single event. It is a sequence of actions. But even more, it is a process of rethinking how to approach the creation and maintenance of applications. There are tangible deliveries when it comes to modernization, the most notable being a modern user interface (UI), such as a web browser or being able to access applications from a mobile device. The UI, however, is only the beginning. There are many more aspects to modernization. Using modern tools and methodologies can significantly improve productivity and reduce long-term cost while positioning applications for the next decade. It is time to put the past away. Tools and methodologies have undergone significant transformation, improving functionality, usability, and productivity. This is true of the plethora of IBM tools and the wealth of tools available from many Independent Solution Providers (ISVs). This publication is the result of work that was done by IBM, industry experts, and by representatives from many of the ISV Tool Providers. Some of their tools are referenced in the book. In addition to reviewing technologies based on context, there is an explanation of why modernization is important and a description of the business benefits of investing in modernization. This critical information is key for line-of-business executives who want to understand the benefits of a modernization project. This book is appropriate for CIOs, architects, developers, and business leaders. Related information Making the Case for Modernization, IBM Systems Magazine


IBM i 7.1 Technical Overview with Technology Refresh Updates

IBM i 7.1 Technical Overview with Technology Refresh Updates

Author: Justin C. Haase

Publisher: IBM Redbooks

Published: 2015-10-29

Total Pages: 952

ISBN-13: 0738440116

DOWNLOAD EBOOK

This IBM® Redbooks® publication provides a technical overview of the features, functions, and enhancements available in IBM i 7.1, including all the Technology Refresh (TR) levels from TR1 to TR7. It provides a summary and brief explanation of the many capabilities and functions in the operating system. It also describes many of the licensed programs and application development tools that are associated with IBM i. The information provided in this book is useful for clients, IBM Business Partners, and IBM service professionals who are involved with planning, supporting, upgrading, and implementing IBM i 7.1 solutions.


Book Synopsis IBM i 7.1 Technical Overview with Technology Refresh Updates by : Justin C. Haase

Download or read book IBM i 7.1 Technical Overview with Technology Refresh Updates written by Justin C. Haase and published by IBM Redbooks. This book was released on 2015-10-29 with total page 952 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication provides a technical overview of the features, functions, and enhancements available in IBM i 7.1, including all the Technology Refresh (TR) levels from TR1 to TR7. It provides a summary and brief explanation of the many capabilities and functions in the operating system. It also describes many of the licensed programs and application development tools that are associated with IBM i. The information provided in this book is useful for clients, IBM Business Partners, and IBM service professionals who are involved with planning, supporting, upgrading, and implementing IBM i 7.1 solutions.


IBM Power Systems Virtual Server Guide for IBM i

IBM Power Systems Virtual Server Guide for IBM i

Author: Dino Quintero

Publisher: IBM Redbooks

Published: 2022-03-30

Total Pages: 300

ISBN-13: 0738460354

DOWNLOAD EBOOK

This IBM® Redbooks® publication delivers a how-to usage content perspective that describes deployment, networking, and data management tasks on the IBM Power Systems Virtual Server by using sample scenarios. During the content development, the team used available documentation, IBM Power Systems Virtual Server environment, and other software and hardware resources to document the following information: IBM Power Systems Virtual Server networking and data management deployment scenarios Migrations use case scenarios Backups case scenarios Disaster recovery case scenarios This book addresses topics for IT architects, IT specialists, developers, sellers, and anyone who wants to implement and manage workloads in the IBM Power Systems Virtual Server. This publication also describes transferring the how-to-skills to the technical teams, and solution guidance to the sales team. This book compliments the documentation that available at the IBM Documentation web page and aligns with the educational materials that are provided by IBM Garage for Systems Technical Education.


Book Synopsis IBM Power Systems Virtual Server Guide for IBM i by : Dino Quintero

Download or read book IBM Power Systems Virtual Server Guide for IBM i written by Dino Quintero and published by IBM Redbooks. This book was released on 2022-03-30 with total page 300 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication delivers a how-to usage content perspective that describes deployment, networking, and data management tasks on the IBM Power Systems Virtual Server by using sample scenarios. During the content development, the team used available documentation, IBM Power Systems Virtual Server environment, and other software and hardware resources to document the following information: IBM Power Systems Virtual Server networking and data management deployment scenarios Migrations use case scenarios Backups case scenarios Disaster recovery case scenarios This book addresses topics for IT architects, IT specialists, developers, sellers, and anyone who wants to implement and manage workloads in the IBM Power Systems Virtual Server. This publication also describes transferring the how-to-skills to the technical teams, and solution guidance to the sales team. This book compliments the documentation that available at the IBM Documentation web page and aligns with the educational materials that are provided by IBM Garage for Systems Technical Education.


Getting Started With DB2 Web Query for System I

Getting Started With DB2 Web Query for System I

Author: Hernando Bedoya

Publisher: IBM.Com/Redbooks

Published: 2007-01-01

Total Pages: 396

ISBN-13: 9780738486765

DOWNLOAD EBOOK


Book Synopsis Getting Started With DB2 Web Query for System I by : Hernando Bedoya

Download or read book Getting Started With DB2 Web Query for System I written by Hernando Bedoya and published by IBM.Com/Redbooks. This book was released on 2007-01-01 with total page 396 pages. Available in PDF, EPUB and Kindle. Book excerpt:


DB2 Universal Database V8 Application Development Certification Guide

DB2 Universal Database V8 Application Development Certification Guide

Author: Steve Sanyal

Publisher: Prentice Hall Professional

Published: 2003

Total Pages: 436

ISBN-13: 9780130463913

DOWNLOAD EBOOK

"The accompanying CD-ROM contains a complete trial version of IBM DB2 Universal Database Personal Edition version 8.1, for Windows operating environments, evaluation copy"--Back cover.


Book Synopsis DB2 Universal Database V8 Application Development Certification Guide by : Steve Sanyal

Download or read book DB2 Universal Database V8 Application Development Certification Guide written by Steve Sanyal and published by Prentice Hall Professional. This book was released on 2003 with total page 436 pages. Available in PDF, EPUB and Kindle. Book excerpt: "The accompanying CD-ROM contains a complete trial version of IBM DB2 Universal Database Personal Edition version 8.1, for Windows operating environments, evaluation copy"--Back cover.


IBM Software for E-Business on Demand

IBM Software for E-Business on Demand

Author: Douglas Spencer

Publisher: Maximum Press

Published: 2004

Total Pages: 388

ISBN-13: 9781931644174

DOWNLOAD EBOOK

Covering the functional characteristics of an on demand computing infrastructure, this book describes the IBM software products that can be used to create a computing infrastructure that has these characteristics. Also discussed is how IBM’s on demand strategy can help a business to make more informed purchasing decisions for IBM application software.


Book Synopsis IBM Software for E-Business on Demand by : Douglas Spencer

Download or read book IBM Software for E-Business on Demand written by Douglas Spencer and published by Maximum Press. This book was released on 2004 with total page 388 pages. Available in PDF, EPUB and Kindle. Book excerpt: Covering the functional characteristics of an on demand computing infrastructure, this book describes the IBM software products that can be used to create a computing infrastructure that has these characteristics. Also discussed is how IBM’s on demand strategy can help a business to make more informed purchasing decisions for IBM application software.