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 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
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.
Related topics