Greetings,
how can I find out what MQTs are defined on a particular table?

Regards,
Damir

OK, first problem solved, I can get the list of MQTs with:

select * from syscat.tables where type = 'S';

So, how do I find the statement text for each MQT?

Damir


---
"Damir" <damirwilder (AT) yahoo (DOT) com> wrote

On Dec 11, 4:29*pm, "Damir" <damirwil... (AT) yahoo (DOT) com> wrote:
Try the following:
select text from syscat.views where viewname='MYMQT';

On 2010-12-11 16:29, Damir wrote:
Reading your original question I thought you where interested in what
mqt's that are dependent on a particular table. If that is the case you
can find out via syscat.tabdep:

select tabschema, tabname
from syscat.tabdep
where (bschema, bname) = (?, ?)

/Lennart

[...]