Results 1 to 1 of 1

Thread: MQT error

  1. #1
    Join Date
    Nov 2007

    Unanswered: Error while creating MQT

    Hi all,

    I am trying to create a MQT but its a giving me an error SQL20058N reason code =4. Can someone tell me where I am doing this wrong. Its basically a pivot query (converting rows to columns) and there are millions of records in the table. What would be the best option to solve this type of issue?

    Thank you all in advance.

    create table bossdev.mqt_attr as
    select party_id,party_type_id, party_entity_id,
    max (case when attr_id = 33 then value end) as ctry,
    max (case when attr_id = 34 then value end) as state,
    max (case when attr_id = 35 then value end) as pos,
    max (case when attr_id = 36 then value end) as expiry,
    max (case when attr_id = 37 then value end) as dormancy
    from bossdev.party_entity_attr
    where party_type_id = 5
    group by party_id,party_type_id,party_entity_id)

    data initially deferred refresh immediate;
    Last edited by tudaykumar; 06-25-08 at 16:23.

Posting Permissions

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