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. |
DBRM/Package Selection
The DBRM/Package Selection screen (see the following figure) displays when a plan is selected with the S line command on the SQL Plan Selection screen (SQL Plan Selection). This screen displays detailed DBRM or Package information.
DBRM/Package Selection Screen
CMD
Specify the line command to be performed on the selected DBRM/Package.
S | Displays detailed information for the selected DBRM or package. The SQL Statement Selection screen (SQL Statement Selection Screen) displays. |
X | Performs an Explain of the entire DBRM or package. If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Analysis Summary screen (SQL Analysis Summary) displays. If you entered 2 for batch processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the Batch Plan Analysis Reports window (Batch Plan Analysis Reports Window) displays. See Explaining-Objects-in-Batch for more information. Note: To explain the DBRM or package, it must contain one of the following SQL statements: DECLARE CURSOR, DELETE, INSERT, SELECT, or UPDATE. If the DBRM or package cannot be explained, the error message NONE EXPLAINABLE displays. |
Sorting DBRMs or Packages
The SORT primary command can be used to change the order in which the DBRM or package entries are displayed. Multiple column names are not accepted. The selected columns are sorted in ascending sequence. The valid column names that can be used with the SORT command are listed below. Abbreviations are noted within parentheses.
- Name (NA)
- Time (TI)
- Dname (DN)
- Version (VER)
For example, to sort the display by dataset name, enter the command SORT DN.