Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Using load function

Option 3, Load, enables you to load data from the File-AID/RDX extract file into multiple related objects. Data extracted from Db2 objects can be loaded into Db2 objects using either Db2 load utility or SQL insert statements. Data extracted from MVS files can be loaded into MVS files.

In this section, you will learn how to use File-AID/RDX’s Auto Create feature to create target objects that do not exist in the target environment you specified. You will then load extracted sample data and submit the load JCL. To illustrate the Load function, you will:

  • Specify the extract file name and load processing option
  • Modify the Target Table Creator ID for Db2 objects
  • Modify the Target Prefix for MVS objects
  • Create missing target objects
  • Assign a default value (literal) to a column in a target object
  • Specify insert/load options and submit the JCL.

Screens of the Load Function

The following list identifies the names of all the Load screens and windows within File-AID/RDX as well as their relationship to each other.

  • Load Reference List
    • Request Details
  • Request File Member List
  • Extract File Specification
    • Create New File
  • Load Menu
    • Load Specifications
    • Source to Target Mapping
      • Column Mapping
      • Default Value Definition
      • Default Value Specification
      • File Mapping Specifications
      • Field Mapping
    • Target Environment
      • Create DB2 Index
      • Create VSAM AIX
      • Create VSAM PATH
    • Existing Data Options
    • Processing Options
    • Save Load Request
    • EDIT- File-AID/RDX Generated JCL

This section provides information about the following topics:

 

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

BMC Compuware File-AID/RDX 21.01