Refreshing the data in a materialized query table

You can refresh the data in one or more materialized query tables by using the REFRESH TABLE statement. The statement can be embedded in an application program, or issued dynamically. To use this statement, you must have DATAACCESS authority, or CONTROL privilege on the table to be refreshed.

Example

The following example shows how to refresh the data in a materialized query table:

   REFRESH TABLE SUMTAB1