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.

Editing the table definition

This section shows you how easy it is to define a new table by editing an existing definition from a similar object and renaming it.

The table editing windows must be displayed (as shown in Table Editing Windows) before you continue.

  1. Edit the Edit Table Information window:

    1. Change the table name by typing EMPTEST over EMP.
    2. Change the database name to a valid name.
    3. Change the tablespace name to DSN8SEMP, the one you just defined.
    4. Change the table creator to your user ID.

    Use Smart Link for valid database name if you are unsure which objects to name.

  2. Create a new column named JOB_GRADE in the Edit Columns window:
    1. Execute the R (repeat) row command next to JOB. The row is duplicated.
    2. Type JOB_GRADE over JOB in the new row to change the name of the COLNAME.
    3. Type VARCHAR over CHAR in the column type field for the new column JOB_GRADE.
    4. Type 40 over 8 in the column length field for the new column JOB_GRADE.

  3. Execute the CONSTRAINTS primary command in the Edit Create Table Information Window.

    The Constraints for Table windows open (see the following figure).

  4. Delete the foreign key relationships in the Referential Constraints window.

    1. Execute the D (delete) row command next to RED in the RELNAME column of the Referential Constraints window.
    2. Execute the D (delete) row command next to NUMBER in the CONSTRAINT NAME column of the Edit Column Constraints window.
    3. Execute the D (delete) row command next to PERSON in the CONSTRAINT NAME column of the Edit Column Constraints window.

    Foreign key relationships must be explicitly deleted with the D row command. Do not use <Cancel> or <End> on the Referential Constraints window in an attempt to delete the foreign key relationship.

  5. Press <End> from the Constraints for Table outer window to return to the Edit Create Table Information window.
    Constraints Windows
    image2021-5-10_11-37-10.png
  6. Execute the LIMITKEY primary command in the Edit Create Table Information Window. The Edit Part Attributes for Table windows open (see the following figure). It displays the limitkey values for each logical partition.
    Edit Part Attributes Window
    image2021-5-10_11-38-29.png

  7. Press the <HELP> key to open the Edit Limitkey Information window where you can generate limit key values, which is helpful when there are many partitions.

    The Edit Limitkey Information window opens (see the following figure). Depending on the column type for the Limitkey you can specifify the length, beginning value, ending value, increment, and/or number of partitions. For date columns, there is also an option to specify end-of-month values.
    Edit Limitkey Information Window

    image2021-5-10_11-40-52.png

  8. Enter the following values:
    1. Select CHARACTER for the Type
    2. Type 6 for the Length
    3. Type 111111 for the Beginning Value
    4. Type 999999 for the Ending Value
    5. Type 8 for the Number of Partitions. (Scroll right to get to the NumParts column.)

  9. Press <Go> to generatete the Limitkey values.

    The Limitkey Values window opens (see the following figure). Review the values. If they are not acceptable, press <End> to return to the Edit Limitkey Information Window and repeat.
    Limitkey Values Window

    image2021-5-10_11-41-48.png

  10. Press <Go> to use the generated Limitkey values.

    The message “Table Limit Keys have been updated.” confirms the update.

  11. Press <End> to return to the Edit Part Attributes Window which now displays the generated values for each partition (see the following figure). These values will be used in the PARTITION BY RANGE statement.
    Part Attributes Values Window

    image2021-5-10_11-42-58.png

  12. Press <End> from the Edit Part Attributes Window to return to the Edit Create Table Information window.

 

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