Create a view
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Right-click the View Container and select New, then View.
- On the New View dialog, specify a name and description for the view.
- Select a Check Option for the view.
- Click OK.
- On the New View dialog, the first task you must do is Select Tables.
The work area on the top half of the dialog is used to specify the tables that are included in the FROM clause of the
CREATE VIEW SQL statement. The selection grid on the bottom half of the dialog is used to specify the columns that make
up the select list of your new view.