Show TOC

View TableLocate this document in the navigation structure

Use

A view table is a view of an existing table. A view table never actually exists physically but is created from the rows of the underlying base table(s).

Table 1: View: Properties

Property

Description (Link to SQL Reference Manual)

View Name

The same rules as for table names apply: Table Name (table_name)

Schema

Schema Name (schema_name)

Replace Existing View

If you choose these option, the view table replaces a previously existing view table.

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.

Table 2: View: General Properties

Property

Description

View Column

Column name in the view table

Table Schema

Schema

Table Name

Name of the base table

Table Column

Name of the column in the base table

Data Type

Data Type (data_type)

Dim

Dimension

Maximum number of characters

Code

Code Attribute

Tenant Type

Only in multi-tenant systems

Tenant type

Not Null

If you select this option, the value for this column cannot be a NULL value.

Column Attributes (column_attributes)

Default

Default value