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.

PROFILE (PRO)

The PROFILE command displays a window (Profile Parameters Window) showing your current user profile defaults and allows you to update them. It is valid during a browse or edit session.

When you make changes to a user profile, they are applied immediately and remain in effect until you alter them. Each user’s profile is independent. Modifications to one user profile have no effect on other user profiles. Changes to some options may not be realized until the next browse or edit session. These options have an asterisk next to them in the Profile Parameters window.

Profile Parameters Window

The Profile Parameters window (see the following figure) displays your current user profile defaults. Type over the parameter values to make a change. Press END to exit the window and save your changes. Type CANCEL to exit the window and cancel your changes.

Profile Parameters Window

AUTOCOMMIT

Specify ON to commit changes each time you press Enter during an edit session. In Related Table Edit, all changes to all tables are saved each time you press Enter. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

AUTOSAVE

Specify ON to save changes each time you press END during an edit session. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

When you issue the END command in a multiple edit session (related or unrelated), all outstanding changes in all open tables are saved if AUTOSAVE is ON. The active window and its dependent windows are closed. If AUTOSAVE is OFF, the Edit End Confirmation window displays for each table in which there are pending changes. For more information on Related Table Edit, see Related-Table-Browse-and-Edit-function. For more information on unrelated edit, see Editing-Multiple-Unrelated-Tables.

Important

If the Auto Commit option is ON, all changes are committed each time you press Enter during an edit session. Therefore, the Edit End Confirmation window is not displayed because there are no outstanding changes when you execute the END command. See AUTOCOMMITabove for information on setting the Auto Commit option.

Since AUTOSAVE is a profile option, its status remains in effect until you change it.

CAPS

Specify ON to automatically change all data entered in lowercase characters to uppercase characters. You can also set this option with the CAPS primary command or through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

OBJECT NAMES UPPERCASE

Specify ON to automatically change all object names entered in lowercase characters to uppercase characters. Specify OFF if you need to edit a table with a DBCS table name or DBCS column name. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

MAXROWS

Specify a numeric value or an asterisk (*) to denote the number of rows to be selected. You can also change this value for individual browse or edit sessions. See Maximum Rows to Select for more information.

NON-DISPLAY

Specify the character that File-AID for Db2 uses to signify nondisplayable data when in browse mode. Does not apply for edit mode. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

NULL ENTRY

Specify the character that, when entered, sets a column to null. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

NULL DISPLAY

Specify the character that displays for null columns. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

SPACES IMPLY NULL

Specify ON to have spaces imply nulls for character columns. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

VARIABLE LENGTH MARK

Specify the character used to indicate the end of a column. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

UPDATE PRIMARY KEY

Specify ON to update primary keys during an edit session. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

Important

In order to be able to update primary key columns in a view, set RETRIEVE UNIQUE KEY INFO to ON before your view editing session. This setting also determines if the primary key, foreign key, and identity column labels appear for views that are being edited or browsed.

SHOW FOREIGN KEYS

Specify ON to show foreign keys during an edit session. Foreign Key information is only shown for local tables. Because Db2 does not maintain an index on the table containing foreign key information, setting this option to ON may have a negative impact on performance. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

VARIABLE LENGTH TRUNCATE

Specify ON to truncate trailing spaces on an insert or update during an edit session. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

INSERT DT/TM/TS DEFAULT

Specify 1 for LOCAL or 2 for GMT (Greenwich Mean Time) to determine the date/time format used as the default for fields defined as not null with default and when CURRENT is used to enter a date, time, or timestamp value. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options. See CURRENT-Date-Time for more information on entering data and time fields.

RETRIEVE UNIQUE KEY INFO

Specify ON to retrieve unique key information before the edit session begins. This value applies only if there is no primary key. Unique key information is only retrieved for local tables. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options.

REPEAT COMMAND PROMPT

Specify ON to display the REPEAT Column Range Specification window (see REPEAT Window) when you enter the REPEAT primary or line command. Specify OFF to suppress the pop-up window. Does not apply when editing Unicode table data.

UPDATE IDENTITY COLUMN

Specify ON to allow update of identity columns in edit. You can also set this option through Option 0, Defaults and User Parms. See Browse-Edit-SQL-Analysis-Display-Options. This applies only to columns set to GENERATED BY DEFAULT. Columns set to GENERATED ALWAYS cannot be edited. If the column is both an identity column and a primary key, then UPDATE PRIMARY KEY must also be ON to edit the column.

MAXIMUM SIZE LOB RETRIEVED

Specify the maximum byte size of LOB data that can be retrieved in a table being browsed or edited. The setting only affects BLOB, CLOB, DBCLOB, and XML data types. Valid values are 2 through 4096. The value must be even and cannot exceed your site configured MAXLOB size. For more information, see LOB_MAXIMUM_DATA_RETRIEVED in the File-AID for Db2 product configuration.