Supporting file specification

The Supporting File Specification screen shown in the following figure is displayed when you select Option 9 - Supporting Files from Extract Menu.

File-AID/RDX ---------  Supporting File Specification  ------------------------
COMMAND ===>                                                                   
                                                                              
Specify Db2 Object Record Layout Information:                                  
  Create layouts  ===> Y        ( Y = Yes;   N = No)                           
  Language        ===> 1        ( 1 = COBOL, 2 = PLI, 3 = FA COBOL)            
  File Name       ===> FRSAMP.MVS.LAYOUTS.NEW                                  
  Member          ===> EXTRACT1 (Blank or pattern for member list)             
  Disposition     ===> NEW      (NEW, SHR)                                     
                                                                              
Specify File-AID/MVS XREF for File-AID/RDX Extract File Information:           
  Create XREF     ===> Y        ( Y = Yes;   N = No)                           
  File Name       ===> FRSAMP.MVS.XREF.NEW                                     
  Member          ===> EXTRACT1 (Blank or pattern for member list)             
  Disposition     ===> NEW      (NEW, SHR)                                     
                                                                              
Specify Data Visualizer File:                                                  
  Create file     ===> Y        ( Y = Yes;   N = No)                           
  File Name       ===>                                                         
  Member          ===>          (Blank or pattern for member list)             
  Disposition     ===> SHR      (NEW, SHR)                                     
                                                                              
  NOTE: Allocating a Data Visualizer file allows for Extract Visualization     
        within the Data Visualizer component of BMC AMI DevX Workbench. 

Related topics

BMC AMI DevX File-AID/MVS
BMC AMI DevX File-AID/Data Solutions

Use this screen to specify what, if any, supporting files should be produced for the extract:

  • Db2 record layout file to which File-AID/RDX will copy the record layouts for all objects to be extracted.
  • XREF file for the data elements (D records) of the extract file.
  • Data Visualizer file to visually analyze extract execution with the Data Visualizer component of the BMC AMI DevX Workbench for Eclipse.

Specify DB2 Object Record Layout File Information:

Create layouts

Specify whether or not to create a COBOL, PL/I, or FA COBOL record layout file for the extracted Db2 objects when File-AID/RDX performs the extract. Creating a record layout allows you, for example, to download the extracted data with File-AID/EX at a later time, or view and compare extract files with BMC AMI DevX File-AID/MVS.

Important

When you ask File-AID/RDX to create only a record layout (Create XREF = NO) for MVS objects, the resulting layout is only for the complete extracted record, not the fields within the record.

Language

Specify whether the record layout will be in COBOL (1), PL/I (2), or FA COBOL (3) format.

1

Create a COBOL record layout.

2

Create a PL/I record layout.

3

Create a FA COBOL record layout.
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.

File Name

Specify the name of the file to which the record layout will be saved.

Important

When also creating an XREF for the extract file and your extract includes MVS objects enter the existing source layout file name, the one used when you defined the relationships. If you specify a different layout file, be sure to copy the layout members from the source layout file into the new record layout file before using the XREF file with BMC AMI DevX File-AID/MVS or BMC AMI DevX File-AID/Data Solutions to access the extract file. The XREF expects all layout members in the same layout file.


Member

If the file you specified in File Name is partitioned, you can enter a member name. If you leave this field blank or specify a pattern, File-AID/RDX displays a Member List pop-up window containing a list of members that match the specified pattern. The only valid pattern character is an asterisk (*). You can create new members by entering the name of the new member in the Member field.

Disposition

Specify the disposition of the record layout file. You can save to existing files with a disposition of SHR. Specify a disposition of NEW to create a new PDS or sequential file.

If you specify NEW in the Disposition field, you must specify the allocation parameters in the Create New File screen.

Specify File-AID/MVS XREF for File-AID/RDX Extract File Information:

Create 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 (D records) of the extract file.

For Db2 objects, the generated XREF member will point to the detail field level layout created with the Create Record Layout function.

For MVS objects, the generated XREF member will point to the detail field level layout that will be left in-place in its source layout file, as specified during the relationship definition.

Creating an XREF allows you, for example, to use File-AID/Data Solutions and modify, or disguise, the data in the extract file before loading the extracted data to a target subsystem.

Yes

Create the XREF. You must also Specify YES in the Create layouts for Db2 objects field to create an XREF even if the extract does not include any Db2 objects.

No

Don’t create an XREF (record layout cross reference).

Important

When your extract includes MVS objects and you ask File-AID/RDX to create XREF and layout information, File-AID/RDX will create the XREF, but not a layout for the MVS data. The XREF points to the source layout as specified when the relationship had been defined.


File Name

Specify the name of the file to which the record layout cross reference (XREF) will be saved.

Member

The XREF file you specified in File Name must be partitioned. Enter a member name. If you leave this field blank or specify a pattern, File-AID/RDX displays a Member List pop-up window containing a list of members that match the specified pattern. The only valid pattern character is an asterisk (*). You can create new members by entering the name of the new member in the Member field.

Disposition

Specify the disposition of the file. You can save to existing files with a disposition of SHR. Specify a disposition of NEW to create a new PDS.

If you specify NEW in the Disposition field, you must specify the allocation parameters in Create New File screen.

Specify Data Visualizer File

Use the following fields to specify file information about the Data Visualizer file (also known as the File-AID/RDX Extract Mainframe Trace file). File-AID/RDX will capture statistics (TPT trace) during extract job execution and save them along with the extract request information to the specified file. The Data Visualizer component of the BMC AMI DevX Workbench for Eclipse can use this file to produce a graphical display with detailed information about extract processing. The insight provided by the Data Visualizer allows you to see where time is spent during long-running extracts, highlighting areas for improvement. You gain a better understanding of complex related extracts, extract requests, and relationship repositories.

Important

Output to Data Visualizer file requires batch extract execution. INTERACTIVE (online) extract does not create a Data Visualizer file (see also MODE).

Create file

Specify whether or not to create a Data Visualizer file when File-AID/RDX performs the extract. The file will contain the extract request information as well as the extract execution information.

Yes

Create the Data Visualizer file.

No

Don’t create a Data Visualizer file.

File Name

Specify the name of the file to which the extract request and extract execution information to be used with the Data Visualizer will be saved. The file may be a PDS, PDSE or a sequential file.

Member

Enter a member name if you specify a PDS or PDSE for the Data Visualizer file. If you leave this field blank or specify a pattern, File-AID/RDX displays a Member List pop-up window containing a list of members that match the specified pattern. The only valid pattern character is an asterisk (*). You can create new members by entering the name of the new member in the Member field.

Disposition

Specify the disposition of the file. You can write to existing files with a disposition of SHR. Existing files must conform to the format for the Data Visualizer file. Specify a disposition of NEW to create a new file.

If you specify NEW in the Disposition field, you must specify the allocation parameters in Create New File screen.

Primary Commands

The following File-AID/RDX-specific primary command is valid on this screen:

END

Saves your input and returns to the Extract File Specification Screen. There are no operands associated with this command.

 

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