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. |
SQL edit
The SQL Edit screen shown in the following figure is an ISPF EDIT session on the SQL source generated by File-AID/RDX using the values you specified on the Selection Criteria screen. It is displayed when you enter the SQL command in the COMMAND field on the Selection Criteria screen and press Enter.
Only the WHERE clause of the SQL statement is displayed as it is the only part of the SQL statement that can be modified for selection criteria.
Use this screen to view or modify SQL source. This can occur when you change the SQL source in the extract criteria file from outside of File-AID/RDX.
SQL Edit Screen
COMMAND ===> SCROLL ===> CSR
*NOTE*
*NOTE* All Columns will be extracted FROM FRSAMP.PART_TABLE
*NOTE*
****** ***************************** TOP OF DATA ******************************
000001 WHERE PART_NUMBER > 'PP0000'
000002 OR PART_NUMBER = 'BB4545'
000003 AND EFFECT_DATE = CURRENT_DATE
****** *************************** BOTTOM OF DATA *****************************
The body of the SQL Edit screen consists of a scrollable data editing area.
Line Commands
ISPF edit line commands are valid on the panel.
Primary Commands
ISPF primary commands are valid on this panel.