Redefine materialize query table as a simple table
To modify a materialized query table to redefine it as a 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 materialized query table that you want to redefine as a simple table,
and then select Definition.
- On the Materialized Query tab, uncheck the Set as materialized
query table field.
- Click OK.