Skip to Content
0
Former Member
Jun 25, 2009 at 05:00 PM

How to Access DB2 MQT (Materialized Query Table) in Crystal 10

168 Views

DB2 V8 has a new construct called a Materialized Query Table (MQT) that is essentially a table containing the data represented by a view. This MQT does not appear in the Database List in Crystal under Table, View or Synonym. I assume it is due to the Database Type in DB2 (M). How can I make Crystal recognize the MQT so I can use it in a report?