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.

Copy Column Selection

The Copy Column Selection screen appears when you specified at the Table Copy Selection screen to create temporary selection criteria and enter selection criteria on the template, and also entered Y in the Column Selection field (see Table-Copy-Selection). It lets you map columns from one table to another.

If you have specified Y in the Column Name Matching field and the column names and data types are identical, they are mapped to the screen in the original order (see the Map field). If column names and data types are not identical, or you specified N in the Column Name Matching field, you must indicate which columns are to be mapped by inserting the appropriate integers in the Map field.

Unmatched column names that are defined as NOT NULL are initialized with a map value of D, meaning that they will be set to the default value for the data type.

To copy from or into distinct type columns both columns must have the same UDT with identical schema, name and built-in data type.

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 Column Selection screen

image2021-3-10_16-45-39.png

From Table

Name of the table or view to be copied.

To Table

Name of the table or view to which the From Table is being copied.

From Table Columns

Columns to be copied.

Data Type

Data types and lengths of the columns to be copied.

Map

Specify in what order the columns of the From Table are to be mapped. Type in the column numbers of the From Table, or enter D to fill in a default value.

To Table Columns

Names of the columns to which you are copying.

Data Type

Data types and lengths of the columns to which you are copying.

Related topics

Table-Copy-Selection

SQL

 

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