Skip to main content

PartnerWorld > Products > Systems, servers, and storage > Technical >

Using SQL views and stored procedures with DB2 Web Query

by Gene Cobb

Last updated: 2008-02-01

PDF iconDownload the white paper (294 KB)
Links to external URLGet Adobe® Reader®

 
Rate this article
  Feedback

© Copyright IBM Corporation, 2008. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the property of their respective holders.

Abstract
This white paper explains how IBM System i developers and database administrators can use IBM DB2 for i5/OS features (views and stored procedures) to provide database security at the row and column level through the use of the IBM DB2 Web Query tool.
Introduction
This white paper explains how IBM System i developers and database administrators can use IBM DB2 for i5/OS features (views and stored procedures) to provide database security at the row and column level through the use of the IBM DB2 Web Query tool. This product was announced in July 2007 as the strategic query and reporting tool for the IBM System i platform. It provides modernized development interfaces and output formats for reports and graphs and leverages the strengths of the DB2 for i5/OS database. Specifically, you will learn how DB2 Web Query can use views and stored procedures to enhance and extend its reporting and graphing capabilities.