I was wondering if anybody could help me with defining a refreshable, user-maintained materialized table.
The documentation states that it is possible to update an user-defined materilized table "by using the LOAD utility, the INSERT, UPDATE, and DELETE statements, as well as the REFRESH TABLE statement".
But when I use the "refresh table"-statements I get the message:
"SQL0159N The statement references "DB2.TESTING1" which
identifies a(n) "USER MAINTAINED SUMMARY TABLE" rather than
a(n) "SUMMARY TABLE".
I have defined the base table as:
CREATE TABLE testing (
id int NOT NULL,
And the materialized table as:
CREATE TABLE testing1 AS
SELECT * FROM testing
DATA INITIALLY DEFERRED
MAINTAINED BY USER;