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*