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.

Step 2—Specifying driving table selection criteria


The following figure is displayed when you enter Yes in the Edit Object Selection Criteria field on the Extract - DB2 Driving Object screen.

Driving Object Selection Criteria

 File-AID/RDX -----------------  Object Selection Criteria  --------------------
 Command ===> END                                               SCROLL ===> CSR
                                                                  
 Specify selection criteria for table FRSAMP.ORDER_TABLE                        
                                                                               
                                                                               
    Column Name           Type(Length)        Where                     More: >
 -  --------------------  ------------------  ----+---10----+---20----+---30---
 P  ORDER_NUMBER          CHAR(6)                                               
    CUST_NUM              CHAR(6)             ='CW3375'                        
    SOC_SEC_NUM           CHAR(11)
    CREDIT_CARD_NUM       CHAR(16)
    ORD_TYPE              CHAR(8)                                               
    ORD_DATE              DATE                                                  
    ORD_STAT              CHAR(8)                                               
    ORD_AMOUNT            DEC(9,2)                                              
    ORD_DEPOSIT           DEC(9,2)                                              
    ORD_LINE_COUNT        INTEGER                                               
    SHIP_CODE             CHAR(2)                                               
    SHIP_DATE             DATE                                                 
    ORD_DESCRIPTION       VCHAR(100)                                            
    ** End of Columns **  

To specify the driving table selection criteria:

In this field…

Do the following:

Where

Type = ‘CW3375’ for column CUST_NUM

Command

Type the END primary command.

Press Enter

File-AID/RDX submits the extract job (remember you entered GO in the Extract - DB2 Driving Object screen) and returns to the Primary Option Menu.

When the extract is completed you will receive a message with a completion code. You can then preform a load or delete using the resulting extract file. You must use the NEW command in the Load or Delete Reference List to access the extract file as extract files from a Single Panel extract are not placed into the reference lists (see also NEW (N)).

Field Names and Descriptions

The following list describes the fields on this screen.

FIELD

DESCRIPTION

Key/Index Indicator

(Untitled 1 byte field) Indicates P Primary key, F Foreign Key, or I High Order Index key (if not Primary or Foreign) for the column as an aid for users to create SQL that will perform well.

Column Name

Displays the names of the columns of the driving object.

Type(Length)

Indicates the data type of each column in the driving object.

Important

  • Distinct type (UDT) columns show either their built-in data types or their UDT names, depending on the status of the UDTSWAP primary command. To switch the display status enter the UDTSWAP command.
  • To view a list of all UDTs that are part of the extract issue the UDTTYPE command.
  • When entering a WHERE clause for a UDT column you must enter the appropriate CAST function manually. Example:
    =CAST('A01' AS TSOID01.DEPARTMENT)
  • Column types CLOB, BLOB, DBCLOB, ROWID, BINARY, VARBINARY, or XML are not eligible for WHERE clauses.

Where

Identifies the operators and values to use to further define the extract selection criteria.

Primary Commands

The following list identifies the primary commands that are available from this screen. For details on the command, see File-AID/Related Data XPERT Reference.

COMMAND

DESCRIPTION

CAPS ON

Switches all entered letters in the WHERE field to uppercase letters.

CAPS OFF

Does not switch lowercase letters in the WHERE field to uppercase.

DOWN

Scrolls toward the end of the column list by the specified scroll amount.

END

Redisplays the Extract - DB2 Driving Object screen.

LEFT

Scrolls toward the left of the Where column by the specified scroll amount.

RIGHT

Scrolls toward the right of the Where column by the specified scroll amount.

SQL

Displays the ISPF/PDF EDIT screen where you can edit or specify selection criteria using SQL syntax.

UDTSWAP (UDTS)

Swaps the display for distinct type columns from UDT name to the built-in data type and length and vice versa. There are no operands associated with this command.

UDTTYPE (UDT)

Lists all distinct data types (UDTs) that are part of the extract. The list displays the schema, UDT name, and the built-in data type and length. There are no operands associated with this command.

UP

Scrolls toward the top of the column list by the specified scroll amount.

Line Commands

There are no line commands associated with this screen.

 

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