DB2® Version 8: The Official Guide

INSTEAD OF Triggers

In many installations, views are used as a way of limiting access to base tables. With a view, a DBA can restrict both the columns and sets of rows that a user can access. However, the use of views causes some difficulties when data modification commands need to be applied to rows in the base table. For instance, a user might have created a customer reference table with the following definition:

						CREATE TABLE CUSTOMERS
						  (
						  CUSTNO      INT           NOT NULL,
						  CUSTNAME    VARCHAR(20)   NOT NULL,
						  PHONE       CHAR(12)      NOT NULL,
						  CREDIT_CARD VARCHAR(20)   FOR BIT DATA NOT NULL,
						  YTD_SALES   DECIMAL(15,2) NOT NULL
						  )
					

This table needs to be made available to a variety of people in the company, including salespeople, the order desk, customer service, and accounts ...