Creating View Tables 
A view table is a view of an existing table. A view table never actually exists physically but rather is formed by the database system from the rows of the underlying table(s).
Prerequisites
You are logged on to the database as a database user.
You have the SELECT privilege for all columns that you want to include in the view table.
More information: SQL Reference Manual, Privilege Specification (priv_spec)
The database is in the ONLINE operational state.
Procedure
In the explorer tree, select the table that you want to use as the basis for the view table.
In the context menu of the table, choose
New 
View. 
Enter the following data:
View: Properties Property
Description (Link to SQL Reference Manual)
View Name
The same rules as for table names apply: Table Name (table_name)
Schema
Check on Insert and Update
If this option is set, you cannot use INSERT or UPDATE statements on the view table to generate any rows that can afterwards no longer be selected via the view table. Resulting rows must fulfill the view table's search condition.
The option is inherited. This means that, if you have defined a view table VIEWTABLE1 with this option and are using VIEWTABLE1 in the FROM condition of a modifiable view table VIEWTABLE2, then only rows that can be selected using VIEWTABLE1 may be added or modified with VIEWTABLE2.
Replace Existing View
If you choose these option, the view table replaces a previously existing view table.
To copy the columns that you want to display in the result view, drag them to the Query Columns area.
Optional: In the Query Columns area, enter search conditions and other attributes of the result view.
Visual Query: Search Conditions and Attributes of the Result View Property
Description
Synonym
Synonym for the column name in the result view
Visible
Column is displayed in the result view.
Order
Listing of column values in the result view
Predicate
Search condition
If you specify a search condition for a column with the data type CHAR, VARCHAR, DATE, or TIME, you must put the relational expression between single quotation marks.
You can enter more than one search condition using AND or OR links. If you want to use one column several times to formulate search conditions, but only want to display it once, you can hide it in the result view.
To enter several search conditions with AND links, enter them in the same row.
To formulate several search conditions with OR links, enter each of these conditions in a new row.
More information: SQL Reference Manual,
In the context menu of the editor window, choose Execute.
You become the owner of the view table. For information about the privileges that the owner of the table view has, see SQL Reference Manual under INSERT-/UPDATE/DELETE Privilege for Owners of the View Table.
More Information
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)