recall MQT definitions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Toralf Förster - 26 Sep 2007 16:09 GMT

I'm wondering where I can find the definition of an already defined
MQT.

Signature

Toralf FÃ¶rster
pgp key 0x7DB69DA3

Reply to this Message

mirof007 - 26 Sep 2007 18:19 GMT

> I'm wondering where I can find the definition of an already defined
> MQT.
>
> --
> Toralf Förster
> pgp key 0x7DB69DA3

The easiest way is probably by running db2look, or browsing in the
control centre. You can also look it up directly in the system
catalogue, it's stored in the TEXT column of the corresponding
SYSCAT.VIEWS entry.

Hope this helps,
Miro

Reply to this Message

Toralf Förster - 27 Sep 2007 08:43 GMT

>> I'm wondering where I can find the definition of an already defined
>> MQT.
[quoted text clipped - 10 lines]
> Hope this helps,
> Miro

yes :-)

Signature

Toralf FÃ¶rster
pgp key 0x7DB69DA3

Reply to this Message

Ian - 26 Sep 2007 18:39 GMT

> I'm wondering where I can find the definition of an already defined
> MQT.

Use db2look, or see the 'TEXT' column in syscat.views.

Reply to this Message