Hello,

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,
name varchar(20)
);

And the materialized table as:
CREATE TABLE testing1 AS
(
SELECT * FROM testing
)
DATA INITIALLY DEFERRED
REFRESH DEFERRED
MAINTAINED BY USER;

Thanks you very much,

Erol

Haven't used this feature . but appears from the doc it was introduced only in FP 7 .. Possibly a bug ... Please open a PMR with IBM

Cheers
sathyaram

Thank you. I will do that.

Erol