Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: User Maintained materialized table

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    Thank you. I will do that.

    Erol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •