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 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
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:
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. 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:
|
Status | Displays the status of target objects. File-AID/RDX can display any of the following messages:
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:
|
X (Exclude) | Enter the X (Exclude) line command for each object you want to exclude from the current load. |
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
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 |
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)
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
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. |
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. |
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
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
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
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)
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. |