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.

Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

SQL Command Manager Utility function


This section describes the SQL (structured query language) Command Manager utility, which allows you to execute SPUFI or SQL without leaving File-AID for Db2.

SPUFI

When you select option 5 from the Utility Selection Menu, File-AID for Db2 accesses IBM SPUFI in Db2, and the SPUFI screen appears (see the following figure).

SPUFI screen

image2021-3-10_22-18-30.png

1 DATASET NAME

Name of the data set to contain the SQL statements; it must have been previously allocated.

2 VOLUME SERIAL

Serial number of the volume where the input data set resides (if it is not cataloged).

3 DATASET PASSWORD

Password, if any, for the input data set.

4 DATASET NAME

Name of a data set to contain the results of processing, which includes a copy of each SQL statement and any output it generated.

5 CHANGE DEFAULTS

Indicates whether you want the CURRENT SPUFI DEFAULTS screen shown before the first processing step. This screen lets you change certain characteristics of the SPUFI processing run and its output.

6 EDIT INPUT

Indicates whether you want to edit the input data set before processing.

7 EXECUTE

Indicates whether the SQL statements in the input data set should be processed.

8 AUTOCOMMIT

Indicates whether changes made to the database by the SQL statements processed should be automatically committed.

9 BROWSE OUTPUT

Indicates whether you want to browse the output data set after the SQL statements in the input data set have been processed.

10 CONNECT LOCATION

Indicates application server to which SPUFI will issue a SQL connect. All SQL statements you submit will then be executed by this server.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*