Load menu

After you selected a load request from either the Load Reference List or the Request File Member List, completed the Extract File Specification, or whenever you enter the MENU command within the load option, File-AID/RDX displays the Load Menu as shown in the following figure.

The Load Menu provides a quick overview of your current load request and its status fields are immediately updated upon return from its suboptions. This allows you to selectively access any of the options or to submit the load request when all load options are set to your liking.

After completing all load specifications, simply select Option 8 and File-AID/RDX submits this load job.

Load Menu

The top of this screen consists of the following fields:

Extract File Name

Name of the file that contains the extracted related data to be loaded.

Description

Displays the description text for the current load request as entered with the Save Load Request option. Using this description is a helpful way to document your load request.

Load Menu Options

Enter the option number (1 - 8) to select the desired option or enter ALL to step through all options in sequence. Alternatively, you may also select one or more options with the S or / line command.

The Current Values are display fields only and are updated upon return from each of the load menu options to reflect the current status and value for the option.

1 - Load Object Specifications

Displays the Load Object Specifications where you can specify Db2 target information such as Db2 subsystem, location, load method, and preserve temporal information, and global object name modifiers for Db2 Creator, Db2 Index name pre- and suffix, MVS high-level qualifier and MVS file name suffix. The option to revert to source names undoes all applied object name modifiers without having to exit the Load function.

Current Values shows the target SSID (Db2 subsystem ID) for all Db2 objects that are part of this load request as well as the load method (Db2 load utility or SQL INSERT statements).

2 - Source to Target Mapping

Displays the Source to Target Mapping panel where you invoke the process of mapping columns between source and target objects. From this panel you also can modify information about the target objects (creator, and tables for Db2 objects; fully qualified file names for MVS objects) to which data in the extract file will be loaded. In the list of objects you can mark objects to be excluded from the load process.

Current Values shows how many objects have been excluded from the load process.

3 - Target Environment

Displays the Target Environment panel that lists all target objects to be loaded including those that don’t exist yet but will be created using the create information from the extract file. For objects to be created you can then edit the create information to fit your specific target environment. Optionally, you can size the objects to be created based on the extract data as opposed to the original source create information.

Current Values displays the number of MVS and Db2 target objects to be created.

4 - Existing Data Options

Displays the Existing Data Options panel where you specify what to do with the existing data of the target objects, whether to delete all records, or replace existing records.

Current Values displays the specified options.

5 - Processing Options

Displays the Processing Options panel where you can specify Db2 load as well as discard processing options.

Current Values displays the specified option.

6 - Save Load Request

Specify whether to save this load request in a file. File-AID/RDX presents the Save Load Request panel where you identify the load request file to save your request to.

Current Values displays None or the name of the load request file.

7 - View JCL

Select this option to view the JCL for this load request. File-AID/RDX shows the Generated JCL panel where you review and modify the load JCL.

8 - Submit JCL

Submits the JCL for this load request. Watch for the message that the job has been submitted and later for the completion message.

Primary Commands

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

ALL

Selects all available load menu options for you to step through in sequence. ALL does not include option 8 - Submit JCL. To submit the load JCL, select option 8 - Submit JCL separately or enter the SUBMIT command in the View JCL panel.

MODE

Enter the MODE command in the Command field to enable execution of the load request interactively (online). Load Menu options 7 - View JCL and 8 - Submit JCL will change to “7 - View REXX” and “8 - Execute REXX” (see Load Menu - ONLINE Mode) to show that the load will be executed interactively when selecting Option “8 - Execute REXX”. MODE acts as a toggle switch.

MODE command is only valid when variable “ALLOW_LOADS_TO_RUN_ONLINE=” is set to Y. For more information, see ALLOW_LOADS_TO_RUN_ONLINE in Extract, Load and Disguise Options.

Load Menu - ONLINE Mode

REFERENCE (REF)

Returns to your load reference list file to start another load request. For more information, see Load Reference List.

REQUEST (REQ)

Returns to a saved load request file to start another load request. For more information, see Request File Member List Screen in section Request file member list.

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.

This section provides information about the following topics: