With the ALTER CACHE
statement, you can disable, enable or refresh cache tables. This requires
the CREATE CACHE or ALTER CACHE privilege.
ALTER CACHE "catalog"."schema"."view"OPTION
“catalog”.’schema”.”view”
Specifies the catalog,
schema and name of the view.
OPTION
Option for the statement.
One of the following:
| DISABLE |
Disables use of the specified cache. References
to the view will use the view rather than the cached data.
|
| ENABLE |
Enables use of the specified cache. |
| REFRESH |
Refreshes the cache table for the specified view. |
ALTER CACHE "catalog1"."schema1"."view1" DISABLE
ALTER CACHE [ "catalog2"."schema2". ] view2 ENABLE
ALTER CACHE [ "catalog3"."schema3". ] view3 REFRESH