DB2 Maestro online Help
MQ Tables
MQ Table is a materialized query table based on a query.
New MQ tables are created within Create MQ Table Wizard. In order to run the wizard you should either
| • | select the Object | Create Database Object... main menu item; |
| • | select the MQ Table icon in the Create Database Object dialog |
or
| • | select the MQ Tables list or any object from that list in the explorer tree; |
| • | select the Create New MQ Table... item from the popup menu |
or
| • | open the schema in Schema Editor and the MQ Tables tab there; |
| • | press the Insert key or select the Create New MQ Table... item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
To create a new MQ Table with the same properties as one of the existing MQ Tables has:
| • | select the Object | Duplicate Database Object... main menu item; |
| • | follow the instructions of Duplicate Object Wizard. |
|
MQ Tables can be edited within MQ Table Editor. In order to run the editor you should either
| • | select the MQ Table for editing in the explorer tree (type the first letters of the MQ Table name for quick search); |
| • | select the Edit MQ Table ... item from the popup menu |
or
| • | open the schema in Schema Editor and the MQ Tables tab there; |
| • | select the MQ Table to edit; |
| • | press the Enter key or select the Edit MQ Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
You can change the name of the MQ Table using the Rename MQ Table dialog. To open the dialog you should either
| • | select the MQ Table to rename in the explorer tree; |
| • | select the Rename MQ Table item from the popup menu |
or
| • | open the schema in Schema Editor and the Aliases tab there; |
| • | select the MQ Table to rename; |
| • | select the Rename MQ Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
|
To drop a MQ Table:
| • | select the MQ Table to drop in the explorer tree; |
| • | select the Drop MQ Table item from the popup menu |
or
| • | open the schema in Schema Editor and the MQ Tables tab there; |
| • | select the MQ Table to drop; |
| • | press the Delete key or select the Drop MQ Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) |
and confirm dropping in the dialog window.
|
Partners
Download
Buy
