Modify an existing materialized query table
To modify a materialized query 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, change the definitions as desired.
- Click OK.