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. When should I use a space announcement banner? Use the space organization announcement after you change the content from a book-like organization (such as User Manual, Configuration Manual, and Administration Guide) to the product model. Use the latest version announcement to push traffic to later versions. You do not need to add this to every previous version, but if you have a specific reason that you want users to be aware—for example, Google searches show content for an obsolete version—use the banner to help users find a relevant version. When an announcement is no longer needed, remove the BMC Space Banner macro.

Copy Row Selection

The Copy Row Selection screen appears by entering T in the Selection Criteria Usage field and T in the Criteria Display Format field on the Table Copy Selection screen (see Table-Copy-Selection). You bypass the Copy Row Selection screen only when you enter N in the Selection Criteria Usage field. The Copy Row Selection screen lets you specify WHERE statements that are used to define specific rows to be copied.

When you complete your entries, type EXECUTE and press Enter or press the associated PF key to complete the copy. A message stating how many rows have been copied appears on the Table Copy Selection screen.

You can execute the SQL primary command on this screen to view or save the SQL File-AID for Db2 generated to complete the task.

Copy Row Selection screen

Table Name

Displays the Creator and name of the table or view to be copied.

Max Rows to Select

Specify the maximum number of rows to be copied. (An asterisk in this field indicates that all rows should be returned.)

Column Name

Column names in the from table.

Type(Length)

Column type and length.

Where

Type the WHERE clauses used to select the rows to be copied. The field can be scrolled left and right. You may use the following delimiters in your clauses:

>	OR	< >
<	> =	BETWEEN
=	< =	IN
¬ =	¬ >	LIKE
AND	¬ <	NOT

Executing or Saving Template, or Viewing/Editing SQL

From the Copy Row Selection screen, you can execute or save the template, or view/edit the SQL. You can also view an alternate display of the template.

Use EXEC to Continue

Type EXECUTE on the command line and press Enter, or press the associated PF key to process the request. The Table Copy Selection screen displays.

SQL to View/Edit SQL Source

Type SQL on the command line, and press Enter. File-AID for Db2 generates all SQL for the current function and places the SQL statements into a data set.

If you specify M-Modify or E-Existing Selection Criteria Usage, this data set must be an existing sequential or partitioned dataset with RECFM=FB and LRECL=80. The data set name is specified on the options panel in the Selection Criteria Dataset Name field. View/edit the data set, and then press END (PF3) to save any changes and exit the window.

If you specify T-Temporary Selection Criteria usage, a temporary data set containing the SQL source is created. An ISPF edit session is initiated, enabling you to view/edit the SQL. If you want to save the SQL source, you must use the ISPF CREATE or COPY command before exiting the edit session.

SAVE

Type SAVE at the command line, and press Enter. The Selection Criteria Dataset Specification window (see the following figure) displays. This allows you to save the current Template Selection Criteria to a data set.

Selection Criteria Dataset Specification for Copy

Dataset

Specify the name of the data set you want the selection criteria to be saved to. File-AID for Db2 prefills this field with the name of the last specified selection criteria dataset name.

Member

Specify the member of the data set you want to save the selection criteria to.

Press END if you do not want to save the current selection criteria to a data set.

SIZE

The SIZE command provides an alternate display of the Copy Row Selection screen which allows 58 positions of the WHERE clause to be displayed, and does not include all of the lines on the original display. The alternate display is designed to maximize the amount of rows displayed on the panel, so that you have a larger area to build a WHERE clause.

Type SIZE at the command line and press Enter. A panel is displayed (see the following figure) with only the Column name and WHERE columns displayed. Enter SIZE again to return to the original display of the Copy Row Selection screen.

Alternate Display of Copy Row Selection Screen