Source Mapping objects are used in WhereScape RED to define source column mappings when there is a requirement for the target table to be populated by more than one set of source tables. These objects support the generation of an update procedure for the target table, sourced from each set of the source tables. Refer to Multi Source Processing for details.
Following is an example of the menu displayed when you right-click a source mapping object. 
WhereScape RED supports keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected table, pressing C displays columns, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.
If a procedure has been locked due to the WhereScape RED utility being killed or failing or a database failure then it can be unlocked via the Properties screen associated with the procedure.
Menu Options | Description |
|---|---|
Maintain Source Mappings | Select this option to launch the Source Mapping tool which enables you to manage the column mappings of the selected target table. |
Execute Update Procedure via Scheduler | Select this option to set up a WhereScape RED scheduler job to execute the source mapping object's update procedure. |
Execute Custom Procedure via Scheduler | Select this option to execute the procedure defined as the 'custom procedure' for the table via the WhereScape RED scheduler. |
Impact | Select this option to perform one of the following:
|
Code | Select this option to view a procedure attached to a table or to rebuild or regenerate the table's update procedure. |
All the other options for source mappings are described under the other object types.