Refresh a materialized query table
To refresh 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 refresh as a materialized query table,
and then select Data -> Refresh.
The summary query is rerun and the data in the materialized query table is replaced.