Refresh a materialized query table

To refresh a materialized query table:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Expand the Tables container.
  5. 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.