Create a materialized query table from an existing simple table
To create a materialized query table using an existing simple table:
- 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.
- Expand the Tables container.
- Right-click the table you want to redefine as a materialized query table,
and then select Definition.
- On the Materialized Query tab, check the Set as materialized
query table field.
- Enter a SQL SELECT statement to define the materialized query table,
and complete the dialog as desired.
- Click OK.