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. |
Step 3—Specifying the Load Object Specification
File-AID/RDX displays the Load Object Specification screen illustrated in the following figure when you select Option 1 from the Load Menu.
All Target Environment and Object Name Modifier fields have already been prefilled with the values of your current profile or the saved load request. These values have already been applied when you entered the Load Menu. If these profile values need to be changed, type the new values in the Name Modifier fields and then place a slash (/) in front of the fields to apply the changes.
Load Object Specification
Command ===> END
Specify Target DB2 Environment:
SSID ===> DSN
Location ===>
DB2 Load Method ===> SQL (SQL = SQL Insert Statement;
DB2 = IBM DB2 Batch Load Utility)
Preserve Temporal ===> N Retain original temporal time data?
(Y/N)
Specify Object Name Modifiers: (/ entry to apply modification)
/ DB2 Creator ===> TSOID01 (Creator for ALL DB2 objects)
_ DB2 Index name prefix ===>
/ DB2 Index name suffix ===> Z
/ MVS high level qualifier ===> TSOID01 (HLQ for ALL MVS objects)
/ MVS file name suffix ===> TEST
/ Revert to source names ===> B (D = DB2 objects;
M = MVS objects; B= Both)
To specify the Target Environment information for objects: | |
---|---|
In this field… | Do the following: |
SSID | Type the ID of the Db2 subsystem on which the tables to be loaded reside. |
Location | Leave blank or type the name of the Db2 remote location at which the Db2 tables to be loaded reside. |
DB2 Load Method | Type SQL |
Preserve Temporal | Type N |
DB2 Creator | Place a slash / in front of the field; your user ID should already be prefilled from the profile. |
DB2 Index name suffix | Type Z in place of the X from the profile, then place a slash / in front of the field. Note: Unless you also select revert to source names, the pre- and suffix values will be added to the current names, for example ORDER_IDX_X will change to ORDER_IDX_X_Z. |
MVS high-level qualifier | Place a slash / in front of the field; your user ID should already be prefilled from the profile. |
MVS File name suffix | Type TEST in place of the NEW from the profile, then place a slash / in front of the field. |
Revert to source names | Place a slash / in front of the field and type B to revert the name modifier values to the source names for both Db2 and MVS object names. |
Command | Type END to exit this panel. |
Press Enter | File-AID/RDX reverts to the source names first and then applies the selected (slashed) name modifiers. File-AID/RDX now displays the Source to Target Mapping screen as it is the next selected panel. |
Field Names and Descriptions
The following list describes the fields on this screen.
Specify Target DB2 Environment | ||
---|---|---|
FIELD | DESCRIPTION | |
SSID | Specify the ID of the Db2 subsystem on which the target tables reside. | |
Location | Specify the name of the location in which the target table resides or will reside. | |
DB2 Load Method | Specify whether you want to load Db2 data using SQL INSERT statements or the IBM Db2 Batch Load Utility. 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. | |
Preserve Temporal | Specify whether to generate the PERIODOVERRIDE clause when Db2 loads data to SYSTEM TEMPORAL tables. Y For all SYSTEM TEMPORAL tables in this load, preserve the contents of the source base and history table regarding the versioning timestamp columns, ignoring the GENERATE ALWAYS clause. N For all SYSTEM TEMPORAL tables in this load, adhere to the GENERATE ALWAYS clause on the versioning timestamp columns, consequently updating those columns as the rows are loaded. | |
Specify Object Name Modifiers | ||
The following fields allow you to apply global object name modifiers. | ||
FIELD | DESCRIPTION | |
DB2 Creator | Specify the authorization ID of the owner of the Db2 target tables. The value in this field defaults to the last value used or entered in your current profile. If you enter a value in this target Db2 Creator field, File-AID/RDX globally updates all Db2 Target table entries with this value. To retain the creator ID from the extract file do not select (slash) this field, but slash the “Revert to source names” option. | |
DB2 Index name prefix | Specify the prefix to be added to the index names in the target environment. Leave blank if you don’t want to specify a prefix. | |
DB2 Index name suffix | Specify the suffix to be added to the index names in the target environment. Leave blank if you don’t want to specify a suffix. | |
MVS high-level qualifier | Specify the high level qualifier for the MVS target files. The value in this field defaults to the last value used or entered in your current profile. If you enter a value in this target high level qualifier field, File-AID/RDX globally updates all MVS target file name entries with this value. To retain the high level qualifier as specified in the extract file do not select (slash) this field but slash the “Revert to source names” option. | |
MVS File name suffix | Specify the suffix you want to add when creating MVS files in the target environment. If a file were named FRSAMP.PARTTABL, adding a suffix of TEST would make the new file name FRSAMP.PARTTABL.TEST. Do not select (slash) the MVS suffix field but slash the “Revert to source names” option to retain the file name as specified in the extract file. | |
Revert to source names | Specify which object types should have all their target object names reverted to the names as specified in the extract file: M (MVS objects only) File-AID/RDX reverts all MVS object names to the source names as specified in the extract file. D (Db2 objects only) File-AID/RDX reverts all Db2 object names to the source names as specified in the extract file. B (Both Db2 and MVS objects) File-AID/RDX reverts all object names to the source names as specified in the extract file. When Revert to source names is slashed all object names of the specified object type(s) revert to the extracted (source) names. If any other modifier items are slashed they will be applied after the source revert. |
Primary Commands
The following identifies the primary command that is available from this screen. For details on the command, see File-AID/RDX Reference.
COMMAND | DESCRIPTION |
---|---|
SQLID | Enter the SQLID primary command to change or view the Db2 SQLID for the current load session. Each load session starts with the default SQLID as specified in the load profile (see also Default SQLID). In the Set SQLID window, enter the desired SQLID. USER is a valid entry and changes the SQLID to match the current userid. If you blank out the SQLID, it defaults to the SQLID as specified in the load profile. |
Line Commands
There are no line commands available from this screen.