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.

Extract—With user profile SAMPMENU

Option 2, Extract, enables you to selectively extract data from a group of related objects (MVS files, Db2 tables or views).

In this section, you will learn how to select the object to drive the extract, select a relationship definition that reflects the driving object, modify the relationship and selection criteria, and submit the extract JCL for processing. To illustrate the Extract function, you will:

  • Select ORDER_TABLE as the driving object.
  • Select extract navigation criteria and extract options.
  • Exclude 2 relationships from the extract and modify the relationship criteria for the other relationships.
  • Define selection criteria for the driving object and an MVS object.
  • Specify the Extract, COBOL Record Layout and XREF file information.
  • Save the extract request to the file FRSAMP.EXTCRIT and member name ORDER and submit the JCL.

Screens and Pop-Up Windows of the Extract Function

The following list identifies the names of all the Extract screens and pop-up windows within File-AID/RDX as well as their relationship to each other. The pop-up windows are listed directly below the name of the screen that it follows:

Extract Reference List

  • Request Details

Request File Member List

Modify Extract Request

  • Modify Extract Request - Object Names
    • Change Command window
    • Find Command window
  • Save Extract Request
    • Create New File

DB2 Driving Object

  • Table List
  • Subsystem ID Selection
  • Location List

MVS Driving Object

  • Catalog Utility File List

Extract Menu

  • Driving Object
  • Extract Scope
    • Extract Scope - Object View
    • Relationship Criteria
    • Relationship Navigation Criteria
    • Relationship Sampling Criteria
    • Graphical Relationship Display
      • Option List
      • Relationship Information
  • Relationship Validation
    • Update Saved Request
  • Unrelated Object Specification
    • Unrelated Object Definition
      • Add Unrelated DB2 Object window
    • Modify Unrelated MVS Object Definition
  • Input Key File Specification
    • Input Key File - Delimited
    • Input Key File - Positional
      • Browse
  • Object Selection Criteria
    • Object Selection Criteria
    • Selection Criteria Menu (MVS)
      • Selection Criteria Options
      • Formatted Selection Criteria
      • View Criteria
      • Extract Criteria Information
  • Output Key File Definition
  • Extract - File Specification
    • Create New File
  • Data Privacy Specification
  • Supporting File Specification
    • Select Layout Dataset Member
  • Checkpoint/Resumption
  • Continue With Load Menu
  • Save Extract Request
  • View - File-AID/RDX Generated JCL
    • Checkpoint/Resumption Confirmation

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