Redefine materialize query table as a simple table

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