Create a materialized query table
To create 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.
- Right-click the Tables container and select New,
then Materialized query table.
On the Table tab:
- In the Table name field, specify a table name.
- In the Table schema field, specify a schema where the table will reside.
- Specify a description (optional) in the Text field.
On the Materialized Query tab:
- Enter the SQL SELECT statement that defines the query upon which
the materialized query table is created. You can optionally click SQL Assist to
build the statement interactively.
- Optionally, check that the syntax of the SELECT statement is valid.
- Optionally, see a preview of the result set generated by the SELECT statement.
- Optionally, populate the table immediately when the table is created.
- Click OK.