Create a materialized query table from an existing simple table

To create a materialized query table using an existing 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 table you want to redefine as a materialized query table, and then select Definition.
  6. On the Materialized Query tab, check the Set as materialized query table field.
  7. Enter a SQL SELECT statement to define the materialized query table, and complete the dialog as desired.
  8. Click OK.