By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

recall MQT definitions

P: n/a
I'm wondering where I can find the definition of an already defined
MQT.

--
Toralf F├Ârster
pgp key 0x7DB69DA3
Sep 26 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sep 26, 11:09 am, Toralf F÷rster <toralf.foers...@gmx.dewrote:
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

Sep 26 '07 #2

P: n/a
Ian
Toralf F÷rster wrote:
I'm wondering where I can find the definition of an already defined
MQT.
Use db2look, or see the 'TEXT' column in syscat.views.

Sep 26 '07 #3

P: n/a
mirof007 wrote:
On Sep 26, 11:09 am, Toralf F├Ârster <toralf.foers...@gmx.dewrote:
>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
yes :-)

--
Toralf F├â┬Ârster
pgp key 0x7DB69DA3
Sep 27 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.