Using data solutions with other File-AID products

File-AID/Data Solutions can be used with record layouts and XREFs created with the following File-AID products:

• File-AID/MVS
• File-AID for IMS
• File-AID for DB2
• File-AID/RDX.

Using File-AID/Data Solutions with File-AID/MVS

File-AID/Data Solutions uses File-AID/MVS record layout and XREF files to create and process change criteria (aging, EURO conversion, date analysis, data translator, data generator, or field exit).

Defining an XREF for File-AID for IMS extract files

1. Build Selection Criteria (Option 6) within File-AID for IMS to identify the IMS segments to unload. Use SEGMENT criteria to extract only those segments that contain dates and would therefore need to be aged. You can use FIELD criteria to limit the IMS segments to a particular test cycle. (i.e. Accounts that were opened in the last year).
2. Execute the File-AID for IMS Extract (Option 4.1) to unload the selected data from an IMS database to a sequential file.
3. Browse the Extract file created in Step 2 above and identify the following:
   1. The length of the prefix which is located on the first record of the extract file in the parameter PREFIX LENGTH = n.
   2. The names of all of the segments included in the extract. This information will be located in Position 19 of each of the subsequent records.
4. Browse the File-AID for IMS XREF (Option 7) for the database that was unloaded in Step 2 above and identify the following:
   1. The name of the data set that contains the layouts for the IMS segments.
   2. The names of the COBOL or PL/I members that are associated with each of the segments identified on the extract file in Step 3.b.

For any segment that is identified as *MULT-RTV*, select the segment by typing an S in the Line CMD area. This will identify the location and data value for each of the Record Type identifiers.

5. Build the File-AID/Data Solutions XREF (Option R) to use with the File-AID for IMS Extract file by entering the following information:

• On the Record Layout Cross Reference screen, enter the name of the data set that contains the IMS layouts in to the Record Layout Dataset field.
• Enter the Prefix Length of the IMS Extract file from Step 3.a above, in the GENERATED FILLER LENGTH field.
• Under the Member column enter the names of the COBOL or PL/I layouts that are needed for each of the IMS segments. These members were identified in Step 4.b above.
• In the CMD area, next to each of the layout members, type SU (Select Unformatted) to identify when File-AID/Data Solutions should use each of these layouts.
• On the Unformatted XREF Definition screen, enter Position 19 as the location on the Extract file where the segment name is located. In the DATA area, enter the name of the segment that corresponds to the layout. Repeat this process for each of the segments/layouts identified.

• For any segment in Step 4.c that was identified as *MULT-RTV*, the following additional information must be entered in the Position columns and Data Value area on the Unformatted XREF Definition screen. In the Position column, you must enter the offset of the field that contains the Record Identifier. This offset is determined by taking the offset identified in Step 4.c above and adding the Prefix Length identified in Step 3.a. In the DATA area enter the Record Identifiers from Step 4.c.

  Example

   

        Position   Length  RO   Data Value
          19               =    ORDR010
  AND     47               =    SC

Using data solutions with File-AID for DB2 extract files

File-AID for DB2 allows you to selectively extract data from one table to a sequential file. You may also generate a COBOL record layout for the extracted table data at the same time File-AID for DB2 creates the extract file. File-AID/Data Solutions can use the extract file and the record layout to create a new changed file or update the extract file. Then use File-AID for DB2 to load the changed data to a new DB2 table.

Defining an XREF for File-AID/RDX extract files

Starting with Release 4.2 of File-AID/RDX, related extract files can be disguised using the File-AID/RDX Data Disguise function. Extracted data in an File-AID/RDX extract file can be disguised as part of the extract process or, as a separate operation, any time thereafter. This also allows you to disguise extracted data in extract files created with a prior release of File-AID/RDX.

However, if your File-AID/RDX installation is an earlier Release than 4.2, follow these instructions to define an XREF for each individual extract file.

File-AID/RDX can be used to extract related data from multiple DB2 tables into one extract file. The extract file will contain the rows from all of the related tables. You can create a COBOL or PL/I record layout member at extract time that describes all of the tables contained in the extract file. Each table described in the record layout contains an 01 level description and the key value for the record type that matches each table.

Use the extract file and the COBOL or PL/I record layout to create an XREF definition. Use the table names in the extract file and record layout member to define the XREF base 01 level names. Select each base name in the XREF listing to specify the key value. The 01 level table name contains the key value used in the first four bytes of the record that uniquely identifies the table record and is used as the selection value for each base.

You can use the extract file and the XREF definition in File-AID/Data Solutions to create your change criteria and process the extracted data. Then use File-AID/RDX to load the related aged data back to a set of DB2 test tables.

1. Use File-AID/RDX to Extract (Option 2) related DB2 tables. Specify extract criteria including which relationships to exclude from the extract, how many rows to extract, and an SQL statement to apply to the table driving the extract. On the Extract - Dataset Specification screen, specify YES in the Create Record Layout field. In order to create an XREF, the Layout data set must be a partitioned dataset (PDS). You must exit File-AID/RDX to allocate the PDS data set for the layouts.
2. On the Record Layout Information screen, enter the name of the record layout dataset to which you want File-AID/RDX to copy the record layouts for extracting all tables. The record layouts can be COBOL or PL/I.
3. When File-AID/RDX has completed the extract process, you may use this record layout dataset in File-AID/Data Solutions to build the XREF file (Data Solutions Option R). Complete the following process to build your XREF in Data Solutions:
   1. On the Record Layout Cross Reference screen, enter the name of the record layout dataset that contains the File-AID/RDX layout in the Record Layout Dataset field.
   2. Specify your XREF dataset and member name, and press <Enter>. File-AID/Data Solutions displays the Define XREF screen.
   3. On the Define XREF screen, type the member name of the layout in the Member column and press <Enter>. Data Solutions displays a list of all the 01 levels.

   4. Select one of the 01 levels, and press <Enter>. Data Solutions returns to the Define XREF screen. Specify an S in the Cmd field to specify the criteria for using this 01 level.

      RECORD-ID-D001   4/AN   EQ    D001Use <PF3> to save your criteria.

   5. Repeat Step c and Step d until all the 01 levels have been defined. Use <PF3> (END) to save your XREF definition for the RDX layout.
4. Now you can use Data Solutions to create change criteria using your new XREF and process it against the data in the extract file.