recall MQT definitions
This is a discussion on recall MQT definitions within the DB2 forums, part of the Database Server Software category; --> I'm wondering where I can find the definition of an already defined MQT. -- Toralf Förster pgp key 0x7DB69DA3...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:06 PM
| |||
| |||
 Re: recall MQT definitions On Sep 26, 11:09 am, Toralf Förster <toralf.foers...@gmx.de> wrote: > 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      |
|
02-27-2008, 02:06 PM
| ||||
| ||||
| Re: recall MQT definitions mirof007 wrote: > On Sep 26, 11:09 am, Toralf Förster <toralf.foers...@gmx.de> wrote: >> 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 |
Linear Mode
