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.