Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. |
Materialized Query Table
The Materialized Query Tables screen (see the following figure), displays when option 11 is selected on the Object Selection menu. It allows you to create, alter, drop, or model an MQT.
Materialized Query Tables Screen
OPTION
Specify the letter of the required option:
C | Create an MQT. |
A | Alter an MQT. |
D | Drop an MQT. |
M | Model an MQT and create a new MQT. |
Specify MQT Information (* or pattern for list) Area
Creator
Specify your creator ID. This field is required. You can also specify a generic name with * (asterisk) or a pattern. This displays a selection window, from which you can select a specific object.
MQT Name
Name of the MQT to be created, altered, dropped, or modeled. This field is required. You can also specify a generic name with * (asterisk) or a pattern. This displays a selection window, from which you can select a specific object.
Specify CREATE MQT Options: (* or pattern for list) Area
Table Creator
ID of the user who created the table on which the MQT is based. This field is required if you are creating an MQT. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Table Name
Name of the table on which the MQT is based. This field is required if you are creating an MQT.
You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.
Related topics