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.

Extract—Db2 single table selective column/delimited extract

Option 2, Extract, enables you to selectively extract data from a group of related objects (MVS files, Db2 tables or views).

In this section, you will learn how to perform a Db2 single table extract that includes only selected columns that can be saved as a standard or delimited extract file. This option is only available for a Db2 single table extract from the Single Panel Extract Function as well as the Extract Menu’s Option 7, Extract File.

Important

Extracted data in delimited file format cannot be loaded using File-AID/RDX’s Load utility.

It can be loaded into other RDBMS or spreadsheets that accept delimited file format.

For this example, your extract options will be taken from the current profile, FRSAMPQK. You will specify the single Db2 table to extract from, specify the delimited extract file options, select the columns you want to include in the extract file, and submit the extract JCL for processing. To illustrate the Extract function, you will:

  • select ORDER_TABLE as the single Db2 table
  • direct the output of the extract to the file FRSAMP.DELIMEXT
  • select the columns to include
  • submit the JCL

Screens and Pop-Up Windows of the Single Panel Extract Function

The following list identifies the names of all the Extract screens and pop-up windows within File-AID/RDX as well as their relationship to each other. The pop-up windows are listed directly below the name of the screen that it follows:

Extract - DB2 Driving Object

  • Subsystem ID Selection
  • Location List
  • Table List (DB2)
  • Relationship Listing
  • Selective Column / Delimited

Delimited Format Options

Object Selection Criteria

  • SQL Edit

This section provides information about the following topics:

 

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