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 4—Specifying Source to Target Mapping


File-AID/RDX displays the Source to Target Mapping screen illustrated in the following figure when you select option 2, Source/Target Mapping from the Load Menu.

Source to Target Mapping

 File-AID/RDX -----------  Source to Target Mapping ----------------------------
 Command ===> CHANGE                                            SCROLL ===> CSR
                                                                               
 Primary Commands: CHANGE, EXCLUDE, UNEXCLUDE                                   
    Line Commands: X = Exclude U = Undo Exclude S = Select for column mapping   
                                                                               
 Extract File: TSOID01.FRSAMP.EXTMENU                                           
                                                                               
 CMD Source / Target                                      Type Status           
 --- ---------------------------------------------------- ---- ----------------
 _   'TSOID01.FRSAMP.CONTACTT'                            VSAM  Object not found
        'TSOID01.FRSAMP.CONTACTT.TEST'                                          
 _   'TSOID01.FRSAMP.CUSTOMER'                            VSAM  Object not found
        'TSOID01.FRSAMP.CUSTOMER.TEST'                                          
 _   'TSOID01.FRSAMP.PARTTABL'                            VSAM  Object not found
        'TSOID01.FRSAMP.PARTTABL.TEST'                                          
 _   'TSOID01.FRSAMP.SUPPLIER'                            VSAM  Object not found
        'TSOID01.FRSAMP.SUPPLIER.TEST'                                          
 _   FRSAMP.CONTACT_TABLE                                 TABLE Object not found
        TSOID01.CONTACT_TABLE                                                   
 X   FRSAMP.CUSTOMER_TABLE                                TABLE Object not found
        TSOID01.CUSTOMER_TABLE                                                  
 _   FRSAMP.ORDER_LINE_TABLE                              TABLE Object not found
        TSOID01.ORDER_LINE_TABLE

To change the target information and exclude an object:

In this field…

Do the following:

CMD

Type X line command in front of CUSTOMIER_TABLE.

Command

Type CHANGE

Press Enter

File-AID/RDX displays the Change Command window so you can globally change the names of target objects.

Field Names and Descriptions

Upper Portion

The upper portion of this screen consists of the following fields:

FIELD

DESCRIPTION

Extract File

Displays the name of the file from which data will be loaded.

Lower Portion

If there are more target objects than can be listed on this screen, you can scroll the lower portion of the screen up and down using standard scrolling commands.

The lower portion of this screen consists of the following fields:

FIELD

DESCRIPTION

CMD

Enter the S (Select) line command in this column to invoke the “Column Mapping Screen” where you to map source columns/fields to target columns/fields.

Enter the X (Exclude) line command for each object you want to exclude from the current load.

Enter the U (Undo) line command for each excluded object you want to include again in the load process.

Source

Displays the fully qualified name of each source object from which data was extracted. The Source line is for display purposes only.

Target

Specify the names of objects to be loaded with the data extracted from the source objects.

For Db2 objects, specify the creator ID for the tables to be loaded. The value in this field defaults to the last value entered. You can change this column:

  • Globally by modifying the value in the Creator field in the Load Object Specification screen, or
  • By issuing the CHANGE command, or
  • By typing over the values in this column.

To load data into a Db2 View:

First, you must have specified the SQL Db2 Load Option in the “Load Object Specifications” screen, then you can enter the Db2 view name of the Target table, if you prefer to load the table using its view. The target view must already exist in the “Target Environment”.

If the view does not exist, File-AID/RDX will create the view as a table.

Important

The Db2 load utility does NOT support enclosing lowercase creator IDs with quotes.

 For MVS Files, specify the fully qualified name of the file to be loaded. The value in this field defaults to the name of the extracted file or the last value entered. You can change the target file name individually by typing over it, or globally with the CHANGE command.

If you specify an object that does not currently exist, File-AID/RDX displays the message Object not found in the Status column and will create it based on the extracted data. For more information about the Auto Create option, see Target Environment.

Type

The object type is indicated in the next column:

  • TABLE (Db2 table or view)
  • FILE (MVS file)
  • VSAM (VSAM cluster)
  • IAM ($IAM cluster)

Status

Displays the status of target objects. File-AID/RDX can display any of the following messages:

  • Object not found
  • View not found
  • Objects differ
  • obj not fnd-DTD
  • obj not fnd-DTU
  • Tbls differ-DTU
  • Objects Mapped
  • Excluded

For details on the command, see File-AID/Related Data XPERT Reference.

Primary Commands

The following primary command is available on this screen. For details on the commands, see File-AID/Related Data XPERT Reference.

COMMAND

DESCRIPTION

CHANGE

The CHANGE command allows you to globally update the target creator id for Db2 tables or target prefixes for MVS files. You need to specify the old string, new string and data type (both is the default.) Enter the CHANGE command by itself and a pop-up window will prompt you for these parameters.

Line Commands

COMMAND

DESCRIPTION

S (Select)

The S (Select) line command invokes the Column Mapping screen for Db2 objects, or the File Mapping Specifications screen for MVS objects, corresponding to the line on which you entered the command. Use this command in the following situations:

  • Source and target objects have columns/fields that have different names, lengths, or data types;
  • Columns/fields were added to the target object or removed from the source object;
  • Source and target objects match, but source columns/fields need to be mapped to different target columns/fields;
  • You want to load default values for certain columns/fields to protect sensitive data.

Important

The S line command is not allowed when the target MVS object does not exist.

X (Exclude)

Enter the X (Exclude) line command for each object you want to exclude from the current load.

Warning

Excluding tables from the Load process may compromise the referential integrity of the tables involved. Negative SQL Codes may be returned if tables are being created during the Load and RI relations exist.

U (Unexclude)

Enter the U (Unexclude) line command for each excluded table you want to include again in the load process.

Change Command Window

File-AID/RDX displays the following Change Command window so you can change the prefixes and/or location/creator id for the Target Objects.

Change Command

image2022-1-18_15-0-26.png

To change the FRSAMP prefix of the MVS target objects:

In this field…

Do the following:

From String

Type FRSAMP or the prefix of your actual displayed target objects

Important

The Change command replaces any matching string in the target object name, not only the prefix.

To String

Type RDXTST

Press End

File-AID/RDX redisplays the Source to Target Mapping screen.

File-AID/RDX redisplays the Source to Target Mapping screen illustrated in the following figure. If the renamed Target Objects don’t exist File-AID/RDX flags the missing objects with a message in the Status field.

Source to Target Mapping (missing objects flagged)

 File-AID/RDX -----------  Source to Target Mapping ----------------------------
 Command ===>                                                   SCROLL ===> CSR
                                                                               
 Primary Commands: Change, EXclude, Unexclude                                  
    Line Commands: X = Exclude U = Undo Exclude S = Select for column mapping   
                                                                               
 Extract File: TSOID01.FRSAMP.EXTMENU                                           
                                                                               
 CMD Source / Target                                      Type Status           
 --- ---------------------------------------------------- ---- ----------------
 _   'TSOID01.FRSAMP.CONTACTT'                            VSAM  Object not found
        'TSOID01.RDXTST.CONTACTT.TEST'                                          
 _   'TSOID01.FRSAMP.CUSTOMER'                            VSAM  Object not found
        'TSOID01.RDXTST.CUSTOMER.TEST'                                          
 _   'TSOID01.FRSAMP.PARTTABL'                            VSAM  Object not found
        'TSOID01.RDXTST.PARTTABL.TEST'                                          
 _   'TSOID01.FRSAMP.SUPPLIER'                            VSAM  Object not found
        'TSOID01.RDXTST.SUPPLIER.TEST'                                          
 S   FRSAMP.CONTACT_TABLE                                 TABLE Object not found
        TSOID01.CONTACT_TABLE                                                   
 _   FRSAMP.CUSTOMER_TABLE                                TABLE Excluded
        TSOID01.CUSTOMER_TABLE                                                  
 _   FRSAMP.ORDER_LINE_TABLE                              TABLE Object not found
        TSOID01.ORDER_LINE_TABLE 

To select a pair of objects for column/field mapping:

In this field…

Do the following:

CMD

Type the S line command next to the CONTACT_TABLE entry.

Press Enter

File-AID/RDX displays the Column Mapping screen.

Column Mapping with default values

When you use the S line command on the Source to Target Mapping screen for a Db2 object, File-AID/RDX displays the following figure where you can modify the system proposed column mapping.

Column Mapping

 File-AID/RDX -----------------  Column Mapping  -------------------------------
 Command ===>                                                   SCROLL ===> CSR
                                                                SSID: DSN      
 Source Table:                           Target Table:                          
  FRSAMP.CONTACT_TABLE                    TSOID01.CONTACT_TABLE               
                                                                               
 Line Commands:                                                                 
   Use Column number to map columns      S - Specify/display column values      
   Blank - For column default value                                             
                                                                               
 Column                                                                         
 Number  Source Columns     Type(Length)  CMD  Target Columns     Type(Length)  
 ------- ------------------ ------------  ---  ------------------ ------------  
 1       CUSTOMER_NUMBER    CHAR(6)       __1  CUSTOMER_NUMBER    CHAR(6)    
 2       CONTACT_ID         CHAR(2)       __2  CONTACT_ID         CHAR(2)    
 3       CONTACT_NAME       CHAR(30)      __3  CONTACT_NAME       CHAR(30)   
 4       TITLE              CHAR(30)      S    TITLE              CHAR(30)  
 5       CONTACT_CODE       CHAR(4)       __5  CONTACT_CODE       CHAR(4)    
 6       ADDRESS            CHAR(30)      __6  ADDRESS            CHAR(30)   
 7       CITY               CHAR(25)      __7  CITY               CHAR(25)   
 8       STATE              CHAR(2)       __8  STATE              CHAR(2)

To specify a literal default value for target column TITLE:

In this field…

Do the following:

CMD

Blank out the __4 and type the S line command for target column TITLE.

Press Enter

File-AID/RDX displays the Default Value Specification  window unless you already have existing default value definitions. In that case, File-AID/RDX displays the  Default Value Definition screen.

Field Names and Descriptions

The following list describes the fields on this screen.

FIELD

DESCRIPTION

Source Table

Displays the name of the table or view you selected for column mapping.

Target Table

Displays the name of the table or view to which the data is to be loaded.

Column Number

Displays the File-AID/RDX generated column numbers for the source table.

Important

A column without a column number indicates that it is not eligible for column mapping, for example columns with Large Object Type (CLOB, BLOB, DBCLOB) and/or ROWID.

Source Columns

Displays the column names for the source table.

Type(Length)

Displays the data type and length for each source column.

CMD

Enter a line command to modify the proposed column mapping.

Target Columns

Displays the column names for the target table.

Type(Length)

Displays the data type and length for each target column.

Important

  • If a Db2 column is a distinct type (UDT) File-AID/RDX displays either its name or its built-in column type. Use the UDTSWAP command to switch the displayed type.
  • Columns with Large Object Type (CLOB, BLOB, DBCLOB) and/or ROWID column types are not eligible for mapping.

Primary Commands

For details on the commands, see File-AID/Related Data XPERT Reference.

COMMAND

DESCRIPTION

END

Completes the column mapping and returns to the Source to Target Mapping screen.

UDTSWAP

Swaps the display for distinct type columns from UDT name to the built-in data type and length and vice versa.

Line Commands

COMMAND

DESCRIPTION

column-number

Enter the source column number (from the Column Number column) in the CMD column next to the target column to which you want to map a source column.

blank

Blank out the CMD field for the column(s) you want loaded with the column’s Db2 default values instead of the extracted source column value..

Lnn (Literal Definition Number)

Enter a previously defined literal definition number when you know that it contains the desired literal value for the selected column. In that case, File-AID/RDX skips Default Value Definition screen. To view or change the literal value, use the S line command instead.

S (Select)

Use this command to define new literal definitions, select, modify, or delete existing definitions. File-AID/RDX displays the Default Value Specification screen unless you already have existing default value definitions (literal definitions).

As you most likely don’t have any existing literal definitions, File-AID/RDX displays the following figure when you use the S line command on the Column Mapping screen.

Default Value Specification

image2022-1-18_15-12-32.png

To enter a literal default value

In this field…

Do the following:

VALUE

Type Professor as the default value to be loaded into target column TITLE for all new rows that will be loaded with the current load, replacing the value of the extracted rows in the column.

COMMAND

Type the END primary command.

Press Enter

File-AID/RDX displays the Default Value Definition screen.

When you use the S line command on Column Mapping screen and you have existing literal definitions, or you ended out of the Default Value Specification window, File-AID/RDX displays the Default Value Definition screen.

Default Value Definition screen

 File-AID/RDX ------------  Default Value Definition  --------------------------
 Command ===> END                                               SCROLL ===> CSR
                                                                SSID: DSN      
 Target Column Name: TITLE                                                 
 Target Column Type: CHAR(30)                                                   
                                                                               
 Line Commands:                                                                 
   S - Select an existing definition          D - Delete an existing definition
   A - Add a new definition                   U - Update an existing definition
                                                                               
 CMD  Number  Type(length)  Value                                               
 ---  ------  ------------  ----------------------------------------------------
  S   L01     CHAR(30)      PROFESSOR                                          
                            ********** End of List *****************    

To map the literal default value L01: to target column TITLE and to return to the Column Mapping screen:

In this field…

Do the following:

CMD

Type the S line command next to the desired literal number.

COMMAND

Type the END primary command.

Press Enter

File-AID/RDX returns to the Column Mapping screen and displays the selected literal for the target column.

After you assigned a literal to a column or field, File-AID/RDX displays the Column Mapping or Field Mapping screen again, showing the assigned literal for the target column/field.

Column Mapping screen with Literal Assigned

 File-AID/RDX -----------------  Column Mapping  -------------------------------
 Command ===> END                                               SCROLL ===> CSR
                                                                SSID: DSN      
 Source Table:                           Target Table:                          
  FRSAMP.CONTACT_TABLE                    TSOID01.CONTACT_TABLE                 
 
                                                                             
 Line Commands:                                                                 
   Use Column number to map columns      S - Specify/display column values      
   Blank - For column default value                                             
                                                                               
 Column                                                                         
 Number  Source Columns     Type(Length)  CMD  Target Columns     Type(Length)  
 ------- ------------------ ------------  ---  ------------------ ------------  
 1       CUSTOMER_NUMBER    CHAR(6)       __1  CUSTOMER_NUMBER    CHAR(6)   
 2       CONTACT_ID         CHAR(2)       __2  CONTACT_ID         CHAR(2)    
 3       CONTACT_NAME       CHAR(30)      __3  CONTACT_NAME       CHAR(30)   
 4       TITLE              CHAR(30)      L01  TITLE              CHAR(30)   
 5       CONTACT_CODE       CHAR(4)       __5  CONTACT_CODE       CHAR(4)    
 6       ADDRESS            CHAR(30)      __6  ADDRESS            CHAR(30)   
 7       CITY               CHAR(25)      __7  CITY               CHAR(25)   
 8       STATE              CHAR(2)       __8  STATE              CHAR(2) 

To return to the Source to Target Mapping screen:

In this field…

Do the following:

COMMAND

Type the END primary command.

Press Enter

File-AID/RDX redisplays the “Source to Target Mapping” screen.

Source to Target Mapping (Columns Mapped flagged)

 File-AID/RDX -----------  Source to Target Mapping ----------------------------
 Command ===> END                                               SCROLL ===> CSR
                                                                               
 Primary Commands: Change, EXclude, Unexclude                                   
    Line Commands: X = Exclude U = Undo Exclude S = Select for column mapping   
                                                                               
 Extract File: TSOID01.FRSAMP.EXTMENU                                           
                                                                               
 CMD Source / Target                                      Type Status           
 --- ---------------------------------------------------- ---- ----------------
 _   'TSOID01.FRSAMP.CONTACTT'                            VSAM  Object not found
        'TSOID01.RDXTST.CONTACTT.TEST'                                          
 _   'TSOID01.FRSAMP.CUSTOMER'                            VSAM  Object not found
        'TSOID01.RDXTST.CUSTOMER.TEST'                                          
 _   'TSOID01.FRSAMP.PARTTABL'                            VSAM  Object not found
        'TSOID01.RDXTST.PARTTABL.TEST'                                          
 _   'TSOID01.FRSAMP.SUPPLIER'                            VSAM  Object not found

To create missing target objects:

In this field…

Do the following:

Command

Type the END primary command.

Press Enter

File-AID/RDX displays the Target Environment screen where you can identify parameters to create the missing target objects.

 

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