Defining views
When you design your database, you might need to give users access to only certain pieces of data. You can give users access by designing and using views. “Using views to customize what data a user sees” on page 104 explains the issues to consider when you design views. This section provides examples of defining views on one or more tables and the effects of modifying view information. 
Coding the view definitions
The name for a view is an identifier of up to 128 characters. The following example shows a view name:
| Object | Name |
|---|---|
| View | MYVIEW |
Use the CREATE VIEW statement to define and name a view. Unless you specifically list different ...
Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
