Source to target mapping

The following panel is displayed when you select Option 2 from the Load Menu.

 Source to Target Mapping

 File-AID/RDX -----------  Source to Target Mapping ----------------------------
 Command ===>                                                   SCROLL ===> PAGE

 Primary Commands : Change, EXclude, Unexclude
    Line Commands : X = Exclude  U = Unexclude  S = select for column mapping  

 Extract File: TSOID01.FRSAMP.EXTRACT                                  
                                                                              
 CMD Source / Target                                      Type  Status           
 --- ---------------------------------------------------- ----- ----------------
 _   'FR.FRSAMP.INVOICE'                                  FILE                   
       'FR.FRSAMP.INVOICE'                                                      
 _   FRSAMP.SUPPLIER_TABLE                                TABLE Objects differ  
       TSOID01.SUPPLIER_TABLE                                                   
 _   FRSAMP.CUSTOMER_TABLE                                TABLE                  
       TSOID01.CUSTOMER_TABLE  

Use this screen to invoke the process of mapping columns between source and target objects. In this list of objects you can also mark objects to be excluded from the load process. On this screen you can also modify the target object names to which data in the extract file will be loaded.

After you complete this screen, use the END command to return to the Load Menu.

Upper Portion

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

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. For more information, see Scrolling.

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

CMD

Enter the S (Select) line command in this column to invoke the Column Mapping where you to map source columns/fields to target columns/fields. For more information on the S line command, See S (Select). For more information on the Column Mapping screen, see  Column Mapping.

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

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

Source

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

Target

Displays the names of the objects to be loaded with the data extracted from the source objects. The target object names are prefilled based on the values specified on the Load Object Specifications or Target Environment panels.

You can change the target names by

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.

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, 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 one of the messages listed in the following table. When there are multiple messages for an object, only the first is displayed.

Target Objects Status Messages

Message

Explanation

Object not found

Indicates that the target object does not exist.

View not found

Indicates that the view specified as a target table does not exist in the target subsystem.

Note: For single table views, File-AID/RDX will create the view as a table.
If you want to load using the view, create the target base table and view manually before you can continue the load process. For the load to be successful the view must be a single table view.

Objects differ

Indicates that the source object and target object have columns or fields that have different names, data types, or lengths; or, the MVS objects have different file attributes, such as record lengths. Use the S (Select) line command to invoke the Column/Field Mapping screen to map differing source and target columns/fields. For more information about the S line command, see S (Select). For more information about the Column/Field Mapping screen, see Column Mapping.

obj not fnd-DTD

Indicates that the target table does not exist, yet matching distinct types (same schema.name) do exist, however, their definitions (built-in types) differ from the source UDTs. Use the S (Select) line command to invoke the Column Mapping screen to map differing source and target columns. For more information about the S line command, see S (Select). For more information about the Column/Field Mapping screen, see Column Mapping.

obj not fnd-DTU

Indicates that the target object does not exist, and the target system does not support UDTs. File-AID/RDX will create a table using the UDTs built-in data types. Use the S (Select) line command to invoke the Column Mapping screen to map differing source and target columns. For more information about the S line command, see S (Select). For more information about the Column/Field Mapping screen, see Column Mapping.

Tbls differ-DTU

Indicates that the source object has columns with distinct data types (UDT), while the target system does not support distinct data types. Use the S (Select) line command to invoke the Column Mapping screen to map differing source and target columns. For more information about the S line command, see S (Select). For more information about the Column/Field Mapping screen, see Column Mapping.

Objects Mapped

Indicates that for this pair of objects one or more columns or fields have been mapped during this load session with the Column/Field mapping screen.

Excluded

Indicates that for this pair of objects has been excluded from the load process.

Not Chg

Indicates that the CHANGE command was not executed for this object as it would have resulted in an invalid object name.

Line Commands

The following File-AID/RDX-specific line commands are valid on this screen:

S (Select)

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


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

See Column Mapping and Field Mapping for more information about the Column or Field Mapping screen, respectively.

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 object you want to include again in the load process.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

CHANGE (C)

The CHANGE command allows you to globally update the target names for Db2 tables or MVS files. In the Change Command Window, specify the ‘from string’ and ‘to string’.

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, then press END. File-AID/RDX will then change all matching strings in the target object names to the new names.

Change Command Window

image2021-10-25_12-13-36.png

From string

Enter the current ‘From string’ (old) you want to replace in the object names.

To string

Enter the ‘To string’ (new) you want to replace the object names.

EXCLUDE (EX)

Enter the EXCLUDE command in the COMMAND field to exclude source/target objects from the load. Use this command in conjunction with the U (Unexclude) line command or UNEXCLUDE primary command when you have a long list of source/target objects displayed and you want to include only a few source/target objects in the load.

Important

File-AID/RDX preserves the hierarchy of the objects when excluding and unexcluding them. A lower object cannot be unexcluded as long as its higher object is excluded.

Example

You exclude all Db2 objects with the EXCLUDE primary command which also excludes all databases, tablespaces, tables, and indexes, etc. Before you can unexclude a table with the U line command, you must unexclude its database and tablespace with the U line command in the  Target Environment Screen as they are not displayed in this Source to Target Mapping screen (see also EXCLUDE (EX) and U (Unexclude)).

Valid parameters for EXCLUDE are:

Db2

MVS

INDEX

VSAM

ALIAS

AIX

SYNONYM

PATH

VIEW

NONVSAM

When entered without a parameter, EXCLUDE displays the Exclude Command Window. See the following figure for an example.

Exclude Command Window

When you enter the EXCLUDE command without parameters, File-AID/RDX will display the Exclude Command Window as shown in the following figure. Select the object status types and object types you want to exclude from the load.

Exclude Command Window

 File-AID/RDX ------------------- Exclude Command  --------------------------
 Command ===>                                                   
                                                  
   Objects Types to Exclude:                       Primary Commands:
      All DB2 objects ===> Y  (Y = Yes; N = No ;      EXCLUDE DB2
      Indexes         ===> N    E = EXCLUDE AND HIDE) EXCLUDE INDEX   
      Aliases         ===> N                          EXCLUDE ALIAS  
      Synonym         ===> N                          EXCLUDE SYNONYM  
      Views           ===> N                          EXCLUDE VIEW     
                                                                     
      All MVS objects ===> N  (Y = Yes; N = No ;      EXCLUDE MVS      
      VSAM            ===> N    E = EXCLUDE AND HIDE) EXCLUDE VSAM     
      VSAM AIX        ===> N                          EXCLUDE AIX      
      VSAM PATH       ===> N                          EXCLUDE PATH     
      NON-VSAM        ===> N                          EXCLUDE NONVSAM  
                                                                      
                                                                      
  ENTER to process, END to return

Select the object status and/or object types to exclude, then press END to exit the window.

Object Types to Exclude

All DB2 objects

Enter Y to exclude all Db2 objects from the load, including databases and tablespaces.

Enter E to exclude all Db2 objects from the load, including databases and tablespaces and hide them from the display.

Enter N and all Db2 objects will not be excluded.

Important

The exclude settings for the following Db2 object types are only activated when Exclude All Db2 objects is set to N.

Indexes

Enter Y to exclude all Db2 indexes. Enter N to unexclude all Db2 indexes.

Aliases

Enter Y to exclude all Db2 aliases. Enter N to unexclude all Db2 aliases.

Synonyms

Enter Y to exclude all Db2 synonyms. Enter N to unexclude all Db2 synonyms.

Views

Enter Y to exclude all Db2 views. Enter N to unexclude all Db2 views.

All MVS objects

Enter Y to exclude all MVS objects from the load.

Enter E to exclude all MVS objects from the load, including databases and tablespaces and hide them from the display.

Enter N and all MVS objects will not be excluded.

Important

The exclude settings for the following MVS object types are only activated when Exclude All MVS objects is set to N.

VSAM

Enter Y to exclude all VSAM files. Enter N to unexclude all VSAM files.

VSAM AIX

Enter Y to exclude all VSAM alternate indexes. Enter N to unexclude all VSAM alternate indexes.

VSAM PATH

Enter Y to exclude all VSAM paths. Enter N to unexclude all VSAM paths.

Non-VSAM

Enter Y to exclude all sequential (non-VSAM) files. Enter N to unexclude all sequential files.

Primary Command

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

UNEXCLUDE (U)

Enter the UNEXCLUDE command in the COMMAND field to include all excluded source/target objects in the load again. Use this command in conjunction with the X (Exclude) line command or EXCLUDE primary command.

The optional parameters Db2, IMS, and MVS limit the UNEXCLUDE command to one of the three object types.

This section provides information about the following topics:

 

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