Extract defaults

The following figure is displayed when you select Option 2 from the RDX Profile Screen. Use this screen to specify the default values for an extract using the current profile.

This screen has a large scrollable area. Be sure to navigate to the bottom of the scrollable area as to not miss any fields. Use the UP and DOWN keys to scroll up or down in this screen.

Extract Defaults - Scrollable Screen

File-AID/RDX ---------------- Extract Defaults ------------------------------
Command ===>                                       SITE Profile: RDXMENU
                                                                   More:      +
-------------------- Locking Values and Navigation --------------------------
  Any profile value setting can be locked so that it can not be changed on the
  FA/RDX function panels. Values can always be changed in the Profile function.
  To LOCK a value place the cursor on the value and press the TOGGLE key.

------------------------- All Extract Request Defaults ------------------------
Extract Scope Options:
   Direct                        ===> Y        (Y = Yes; N = No;
                                                P = Plus; C = All Children Only)
   Parents                       ===> Y        (Y = Yes; N = No)
   Siblings                      ===> N        (Y = Yes; N = No)
   Indirect                      ===> N        (Y = Yes; N = No)

   Default detail view           ===> N        (N = None, O = Object,
                                                R = Relationship)

   Maximum cycles                ===> 1        (* for no limit)
   Maximum rows/records
     from all objects            ===> *        (* for no limit)
   Action at maximum count       ===> Q        (Q = Quiesce, S = Stop)
   Extract w/ Uncommitted Reads ===> N        (Y = Yes; N = No)

File Options:
   Capture View DDL              ===> N        (Y = Yes; N = No)
   Capture Alias DDL             ===> N        (Y = Yes; N = No)
   Capture Synonym DDL           ===> N        (Y = Yes; N = No)

   Create File-AID/MVS XREF      ===> N        (Y = Yes; N = No)
   Create record layouts
     for DB2 objects             ===> N        (Y = Yes; N = No)
   Language                      ===> 1        (1 = COBOL, 2 = PL/I;
                                                3 = FA COBOL)
   Use DB2 Image Copy            ===> N        (Y = Yes; N = No)
   DB2 Format                    ===> 2        (1 = Unicode;
                                                2 = Compatibility;
                                                    convert Unicode;
---------------------------- Driving Object Defaults --------------------------
DB2 Object Defaults:
   Default SQLID:                ===> USER
   Convert To Upper Case?        ===> Y        (Y = Yes; N = No)

DB2 Environment:
   DB2 Subsystem                 ===> *
   Location                      ===>
   Creator                       ===>
   Table Name                    ===>

Driving Object Input Key File Options:
   Extract driven by
     Input Key file              ===> N        (Y = Yes; N = No)
  -
-------------------------- Panel Customization ------------------------------
Extract Panel Flow Options:
   Default driving object type   ===> DB2      (DB2 or MVS)
   First extract panel           ===> R        (R = Recently Referenced List;
                                                F = Saved Request File;
                                                S = Single panel extract)
   Display Extract Menu          ===> Y        (Y = display Extract Menu
                                                N = display first flow panel
                                                    if you select N you must
                                                    have at least one FLOW
                                                    menu option below)
Extract Menu contents:
  1 - Driving Object             ===> SHOW      Place the cursor on value and
  2 - Extract Scope              ===> SHOW      press TOGGLE to change value.
  3 - Unrelated Objects          ===> SHOW       SHOW = Include on extract menu.
  4 - Input Key File             ===> SHOW       LOCK = Lock menu choice.
  5 - Selection Criteria         ===> SHOW       FLOW = Include on the extract menu
  6 - Output Key File            ===> SHOW              and pre-select the option
  7 - Extract File               ===> SHOW              for flow mode navigation.
  8 - Data Privacy               ===> SHOW
  9 - Supporting Files           ===> SHOW
10 - Checkpoint/Resumption      ===> SHOW
11 - Continue with Load         ===> SHOW
12 - Save Extract Request       ===> SHOW
13 - View JCL                   ===> SHOW
14 - Submit JCL                 ===> SHOW

All Extract Request Defaults Area

Extract Scope Options Area

Specify the Navigational Criteria Options associated with the current profile. For more information, see Extract-Scope-panel.

Direct

Specify to extract the dependents (children) of the driving object and their dependents.

Extract the dependents of the driving object and their dependents (default).

Do NOT extract the dependents of the driving object and their dependents.

(All Children only) Extract the dependents of the driving object and all of their dependents only. This option ignores all other Navigational Criteria Options (DPSI) settings, resets them to DPSI=CNNN, and cannot be modified during the extract specification.

Using the C method to extract data and only its dependent data can lead to extracted data that is not loadable because of referential integrity issues due to the omitted related parent data. This can be useful for extracting specific data that is then used for a purge procedure.

(Plus) Extract all of the direct relationships of the driving object, i.e. all of its parents and first level dependents only. Direct "Plus" means resolve all objects’ parents until there are no more parents to return. This option ignores all other Navigational Criteria Options (DPSI) settings, resets them to DPSI=PYNN, and cannot be modified during the extract specification.

Important

The C and P settings for Direct can only be set in the profile. The profile settings are used to build the relationship tree with its related objects when starting an extract specification.

Parents

Specify to extract parents of all extracted data to maintain the integrity of the extracted data.

Siblings

Specify to extract other dependents of the extracted parents from the same relationships.

Indirect

Specify to extract other dependents of the extracted parents from other relationships.

Specify the Detail Display Options. For more information, see Extract-Scope-panel.

Default Detail View

Specify which detail extract scope view is displayed when you enter the Extract Scope display:

None does not display either of the detail extract scope panels.

Object displays the Extract Scope - Object View panel, listing all objects related to the driving object from which to extract data.

Relationship displays the Extract Scope - Relationship Criteria panel, listing all the relationships associated with the driving object.

Specify the extract quantity options. For more information, see Extract-Scope-panel.

Maximum Cycles

Specify the number of extract cycles after which the extract process should stop. Enter a number between 1 and 99, or an asterisk (*) to specify no cycle limit.

Maximum Rows From All Objects

Specify the maximum number of rows you want to extract from all related objects. Enter an asterisk (*) to set no limit.

Action at Maximum Count

Specify how the extract should terminate when the maximum count has been reached:

Quiesce resolves all orphan records after maximum count has been reached. (May result in more records than the maximum count.)

Stop does not resolve possible orphan records (may extract dependent records without their parents).

Extract w/ Uncommitted Reads

Specify whether File-AID/RDX should extract data from Db2 objects that include Uncommitted Reads or not.

Whether the value entered here will be used in the extract screens depends on the setting of the UNCOMMITTED_READ_DEFAULT parameter of the Db2 Environment PARMLIB member. For more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment.

File Options Area

Capture View DDL

Specify whether the DDL for Db2 View objects should be saved in the Extract file in order for File-AID/RDX to create Db2 views for the Load process.

Capture Alias DDL

Specify whether the DDL for Db2 Alias objects should be saved in the Extract file in order for File-AID/RDX to create Db2 Alias objects for the Load process.

Capture Synonym DDL

Specify whether the DDL for Db2 Synonym objects should be saved in the Extract file in order for File-AID/RDX to create Db2 Synonym objects for the Load process.

Create File-AID/MVS XREF

Specify whether or not to create a BMC AMI DevX File-AID/MVS XREF (record layout cross reference) file when File-AID/RDX performs the extract. File-AID/RDX will create the record layout cross reference for the data elements of the extract file. For more information, see File-AID/MVS XREF File.

Create Record Layouts for DB2 objects

Specify whether or not to create a COBOL, PL/I, or FA COBOL record layout file when File-AID/RDX performs the extract. For more information, see File-AID/RDX Record Layout File.

Language

Specify whether the record layout will be in COBOL (1), PL/I (2), or FA COBOL (3) format. FA COBOL (3) creates a File-AID COBOL layout with special type VAR for Db2 column type VCHAR or VC (see also Data Type Values), for example when the FIRSTNME column is defined to Db2 as VARCHAR(12), with FA COBOL it will be generated as 10 FIRSTNME PIC X(12) VAR. Use option 3, FA COBOL when you need to define disguise criteria for Db2 tables with column type VARCHAR.

Use Db2 Image Copy

Specify whether File-AID/RDX should extract data from the most recent full Db2 Image Copy or not. File-AID/RDX must be executed from an authorized library. This option is only available if your site installation set the parameter variable ALLOW_EXTRACT_FROM_DB2_IMAGE_COPY to Yes. For more information, see ALLOW_EXTRACT_FROM_DB2_IMAGE_COPY in File-AID/RDX Product Configuration.

Db2 Format

Specify whether Db2 data extracted from tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format.

Unicode option will write the data using Unicode encoding without utilizing IBM z/OS Conversion Services.

Compatibility format will maintain the EBCDIC encoding utilizing IBM z/OS Conversion Services used in previous releases of File-AID/RDX (default).

Driving Object Defaults Area

Db2 Object Defaults Area

Default SQLID

Specify the Db2 SQLID to be used during an extract using this profile.

Convert To Upper Case

Controls whether File-AID/RDX always converts lowercase characters to uppercase for Db2 objects (creator IDs and table names, for example). If set to YES (default), you must enclose lowercase characters in quotes to prevent conversion to uppercase (example: "order_table" remains lowercase, but order_table converts to ORDER_TABLE. Set it to NO to allow lowercase characters. NO is recommended for DBCS mode.

Important

Db2 utilities do NOT support enclosing lowercase creator IDs with quotes.

Db2 Environment Area

Db2 Subsystem

Specify the Db2 subsystem ID for the Db2 objects to be extracted using this profile.

Location

Specify the location of the object you want to drive the extract if it resides in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.

You may leave this field blank if the table you want to drive the extract is in the Db2 subsystem in the DB2 Subsystem field.

Creator

Specify the authorization ID of the owner of the table, view, synonym, or alias that you want to drive the extract process using this profile.

Table Name

Specify the name of the table, view, alias, or synonym that you want to drive the extract process using this profile. For more information about how File-AID/RDX supports view, aliases, and synonyms in Extract, see Use of Db2 Views and Use of Aliases and Synonyms.

Driving Object Input Key File Options

Extract driven by Input Key file

Specify Yes only when you are using an input (external) key file as selection input criteria for the driving table. No is the default.

Panel Customization

The profile also stores information on what panels will be part of the online extract specification process, allowing you to customize the flow through the extract panels.

Extract Panel Flow Options

Default driving object type

Specify whether default driving object for the extract is a DB2 or MVS object.

First extract panel

Specify which panel displays first when selecting Option 2 Extract from the File-AID/RDX Primary Option Menu.

Reference List (default)

Request File

Single panel extract

Display Extract Menu

Yes will display the Extract Menu, No will bypass the display of the Extract Menu and go directly to the first FLOW panel, unless Single Panel Extract has been set. In that case, No disables the MENU command on the Extract - Db2 Driving Object and Extract - MVS Driving Object panels, not allowing you to switch to the full Extract Menu.

Extract Menu contents

For each of the Extract Menu options you can specify whether the menu option will be displayed, locked or its selection automatically included in the extract panel flow.

Place the cursor on value in each field and press TOGGLE (PF4) to change the value.

The toggle values are:

SHOW

Include on extract menu.

LOCK

Lock menu choice.

FLOW

Include on extract menu and pre-select the option for flow mode navigation. When your first extract panel is either Reference List or Request File and Display Extract Menu is set to No, you must set at least one Extract Menu option to FLOW.