In the navigation tree, navigate to the
Views folder by expanding
Database > My Systems > Catalogs > Schemas > Views.
Right-click on the
Views folder and select
Create View from the context menu.
The
Create View wizard launches with
General Properties as the default selection.
Create View
Click
General Properties tab.
Enter the name of the view to be created.
Specify Attributes by selecting or clearing
Similarity Check and
With Check Option. For more information, see
HPE NonStop SQL/MX Reference Manual
.
The view is created in the schema from where you launched the
Create View wizard. To create a view in a different catalog or schema, select another catalog and schema from the list displayed in the schema area.
Click
Headings and Expressions tab.
Add, edit, or remove column names and headings for a view by using the
Add,
Edit, and
Remove buttons. Adding column names and headings are optional. While adding a column, you must specify the column name and the heading is optional.
In the
Query Expression pane, you can type an SQL/MX expression to define the view. This excludes headings, similarity check, location, and check options.
In the
Location tab, select the system and volume name where the view will reside.
You can let SQL/MX determine the name of the physical file for the view or enter the file name in the text box. The file name must start with a name and have six characters. It can be alphanumeric.
Optional. Click
Preview tab to view the DDL statement that is constructed from the inputs provided.
You cannot modify this text. If there are any errors in the view creation, it is displayed in this tab.
Click
Back, to modify the information in the previous tabs. The changes are automatically be reflected in the DDL statement.
