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.

Existing Data Options

The following figure is displayed when you select Option 4 from the Load Menu. The Existing Data Options screen displays the list of objects that will be loaded with the data from the extract file.

Existing Data Options

File-AID/RDX ------------------ Existing Data Options -------------------------
Command ===>                                                   SCROLL ===> PAGE
Primary commands: Change

Extract File: TSOID01.FRSAMP.TEST3
  Insert/Load Option: SQL

                                                     Record   Del Replace Del/
Object Name                                    Type Count    All Matches Def
---------------------------------------------- ---- -------- --- ------- ----
TSOID01.CUSTOMER_TABLE DB2 3 NO    YES   NO
TSOID01.PART_TABLE DB2 8 NO    YES   NO
TSOID01.CONTACT_TABLE DB2 5 NO    YES   NO
TSOID01.ORDER_TABLE DB2 3 NO    YES   NO
TSOID01.ORDER_LINE DB2 10 NO    YES   NO
TSOID01.SUPPLIER_TABLE DB2 8 NO    YES   NO
** END OF LIST **

Use this screen to specify whether or not existing data should be deleted before objects are loaded and whether or not rows with matching data (duplicate keys) should be replaced.

For MVS objects, you may also select the option to delete an existing target file and redefine it before loading data.

The body of this screen consists of an upper portion and a lower portion.

Upper Portion

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

Extract File Name

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

Db2 Processing Options Area

Insert/Load Option

Displays which Db2 load option you selected on the Load Object Specifications screen:

SQL

Perform the load using SQL INSERT statements. This option allows you to update rows if they already exist.

DB2

Perform the load using the IBM Db2 Batch Load Utility.

Lower Portion

The lower portion of the screen consists of a list of objects that File-AID/RDX will load. If there are more entries on the list than will fit on the screen, you can scroll the list up and down using standard scrolling commands. For more information, see Scrolling.

Object Name

Displays the fully qualified name of the object to be loaded. If it is a Db2 object it includes the creator ID of the owner of the table and index that will be loaded.

Type

The object type is indicated in the next column

- Db2
- File (MVS)

Record Count

Indicates the number of records (rows) to be loaded into each target object.

Del ALL

Specify whether File-AID/RDX should delete ALL of the data residing in the target objects before it loads data from the extract file. For Db2 tables, Db2 delete rules are in effect.

Yes	File-AID/RDX generates a step in the JCL to delete all rows from the specified object before loading data.You cannot specify Yes in this field for objects marked to be created; they do not exist and, therefore, do not contain data.
No	Indicates that the data is to be loaded into objects without deleting existing rows. Important When loading into a SYSTEM TEMPORAL table that already contains data, you must consider potential data conflicts when NOT replacing all data in the table. The conflicts can occur because of duplicate values in the three timestamp columns that are part of SYSTEM TEMPORAL tables.

Replace Matches

When you are adding data to an object that is not empty and the INSERT operation fails because the row or record already exists, specify whether or not it should be replaced.

Yes

For MVS:
If the target object is indexed (KSDS), data from the extract file will replace existing data in the target object.For Db2:
If the target Db2 table has a unique index, data from the extract file will replace existing data in the target table.

For MVS:
If the target object is indexed and an existing target record has a unique key that matches the data from the extract file, the data from the extract file will be discarded.

For Db2:
If the target table has a unique index and an existing target row has a unique key that matches the data from the extract file, the data from the extract file will be discarded. If the target table does not contain a unique index and rows to be loaded already exist, no data will be discarded.

Del/Def

MVS files only. Specify whether File-AID/RDX should delete the target file and then redefine it before it loads data from the extract file.

Yes	File-AID/RDX generates a step in the JCL to delete the object and then create it again before loading data.
No	Appends data to the existing target object.

Primary Commands

The following File-AID/RDX-specific primary command is valid on this screen:

END

The END command returns to the Load Menu.

CHANGE (C)

The CHANGE command allows you to globally change the value (YES or NO) for all selected fields (Del All, Replace Matches, or Del/Def) displayed in the list. Specify the change’ from string’ and change ‘to string’ in the CHANGE Command Window.

When globally changing the Del/Def value to YES, File-AID/RDX changes only the values for MVS objects as this field is protected for Db2 objects.

CHANGE Command Window

When you enter the CHANGE command, File-AID/RDX displays the CHANGE Command Window as shown in the following figure. Enter the Change ‘from string’ and the Change ‘to string’ values (either YES or NO) you want to change globally for all selected fields to act upon. Select the fields (Y) the CHANGE command should be applied to, then press END to execute the change and exit the window.

CHANGE Command Window - Existing Data Options

From string

Enter the current From (old) string, YES or NO, you want to change to the To (new) string in the fields to act on.

To string

Enter the To (new) string, YES or NO, you want to replace the From (old) string with in the fields to act on.

Del All

Enter Y if the global change is to be applied to the Del All field for all objects.

Replace Matches

Enter Y if the global change is to be applied to the Replace Matches field for all objects.

Del / Def

Enter Y if the global change is to be applied to the Del / Def field for all objects.