Deriving Views › View Summary

View Summary

The following list summarizes the steps involved in deriving a view through the Automatic System Facility:

1. Name the view by typing a unique name in the Table Name field on the Activity Selection screen.
2. Designate the table as a VIEW by selecting the Define Table function ([PF2]) from the Activity Selection screen and entering view in the View/Stored field on the Table Definition screen.
3. Specify the source tables and the join criteria by typing the name of the first source table in the Table Name field under the Source Table #1 heading, and the name of the second source table in the Table Name field under the Source Table #2 heading. Type the names of the columns on which the two tables are to be joined.
4. Choose the columns by deleting columns from the table definition or by excluding columns from the screen display. Delete columns by erasing the column names; exclude columns by erasing the columns' display sequence numbers.
5. Add columns by entering column names and widths and, optionally, column entry types on the Column Definition screen. Access the Extended Column Definition screen for the columns added and specify a CALCULATION that defines each column. Columns added to views are work columns. The data displayed in a work column is not stored in the database.
6. Select the rows to be included in the view by selecting the Extended Selection Definition function ([PF3]) from the Column Definition screen. Define selection conditions on the Extended Selection Definition screen.
7. Generate the view by returning to the Table Definition screen and selecting the Generate function ([PF3]).
8. Display, select, and change rows in the view by selecting the Display/Change Data ([PF4]) and Select Data ([PF5]) functions from the Activity Selection screen.