Modify an existing materialized query table

To modify 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 redefine as a materialized query table, and then select Definition.
  6. On the Materialized Query tab, change the definitions as desired.
  7. Click OK.