How to compare files in eclipse

You can use the Eclipse UI perspective to compare data sets or members to see what records are inserted, deleted, matched, or changed.

You can use the Eclipse UI perspective to compare data sets or members to see what records are inserted, deleted, matched, or changed.

This article describes how to use the compare feature to address the following scenario.

You are a quality assurance engineer responsible for testing business applications. The development team has provided you with a performance enhancement to a program used to update customer information for the billing and collection system. The program has been altered for efficiency but is expected to produce the same result as the original program version. In addition to measuring the performance improvement, you need to verify that the output from the new program is the same as the output from the old program.

1. Open the Directory List view in the perspective.

2. Select from the Directory List view one of the data sets or members that you want to compare.

3. Right-click the data set or member and select Utilities, Compare.The Compare Data Set Utility wizard opens.

4. Complete the following fields on the Old Data Set page, or verify that the prefilled information is correct:

   • Specifies the name of the first data set that you want to compare.

   • Specifies the name of the member that you want to compare. Perform a wildcard search to select more than one member. Enter an asterisk (*) to compare all members. This field is only active when comparing members in a PDS.

6. Specify the name of the data set and member as on the New Data Set page. This identifies data set and member that you want to compare to the Old data set. If you are comparing members in a PDS, the Old and New data sets must both contain the members you want to compare.

8. Set the following options, which produce the best report for this scenario. Use F1 help to learn about the other settings available that best meet your needs for a specific compare report.

   • Mismatched

9. (Optional) Specify a layout for the old and new data sets. You can select Use old data set layout to use the specified layout for both the old and new data sets. Do one of the following in the Old data set layout and the New data set layout groups:

   • Select from the drop-down list a layout displayed in your Layout view.

   • Specify the layout data set and member name.

11. Click Next.A summary page shows the options that you have selected.

12. Click Finish.The summary results of your compare are displayed in the Report view.

The compare report summary displays in the Report view after completing the Compare wizard. The summary report shows the names of the data sets and members you compared, the layout used, the options you selected, the number of records compared, and whether the compare was successful.

Click the View Detailed Report icon (

The following detailed compare report shows the compare of two data sets where record 59 in the OLD data set was deleted in the NEW data set. The SUMMARY REPORT section displays below the details. The summary shows that 60 of 61 records matched, no records were changed or inserted, and one record was deleted.

000001 1CA File Master Plus V9.0 Page 1 000002 System CA11 2013-05-28 15:42 000003 000004 Compare Report Old File AD1DEV.FMMVS90.DEMO.BASE.CUSTFILE Key pos = 2 Key len = 7 000005 New File JOHSA08.FMMVS90.DEMO.BASE.CUSTFILE 000006 000007 Key=0000867 000008 FFFFFFF 000009 0000867 000010 Delete Old Rec #59 000011 Old Record Length = 160 000012 Pos *----------FIELD NAME-------------* FORMAT *---+----1----+----2----+----3----+----4 000013 1 03 CUST-REC-TYPE C 1 1 000014 2 03 CUST-ID C 7 0000867 000015 9 03 CUST-NAME C 15 JAN SMITH 000016 24 03 CUST-STREET C 18 48 WILLOW WAY 000017 42 03 CUST-CITY C 12 NEW HAVEN 000018 54 03 CUST-STATE C 2 CT 000019 56 03 CUST-ZIP-CODE C 10 06032-1234 000020 56 05 CUST-ZIP N 5 6032 000021 61 05 FILLER C 1 - 000022 62 05 CUST-ZIP-PLUS N 4 1234 000023 66 03 CUST-MNTHLY-PYMNTS(1) PS 3.2 988.41 000024 69 03 CUST-MNTHLY-PYMNTS(2) PS 3.2 224.30 000025 72 03 CUST-MNTHLY-PYMNTS(3) PS 3.2 8.06 000026 75 03 CUST-MNTHLY-PYMNTS(4) PS 3.2 503.24 000027 78 03 CUST-MNTHLY-PYMNTS(5) PS 3.2 91.25 000028 81 03 CUST-MNTHLY-PYMNTS(6) PS 3.2 243.57 000029 84 03 CUST-MNTHLY-PYMNTS(7) PS 3.2 301.21 000030 87 03 CUST-MNTHLY-PYMNTS(8) PS 3.2 602.49 000031 90 03 CUST-MNTHLY-PYMNTS(9) PS 3.2 847.23 000032 93 03 CUST-MNTHLY-PYMNTS(10) PS 3.2 663.22 000033 96 03 CUST-MNTHLY-PYMNTS(11) PS 3.2 113.42 000034 99 03 CUST-MNTHLY-PYMNTS(12) PS 3.2 237.21 000035 102 03 CUST-TOTAL-MNTHLY-PYMNTS PS 5.2 94170.78 000038 000039 000040 S U M M A R Y R E P O R T 000041 000042 Old Records Processed 61 000043 New Records Processed 60 000044 000045 Records Matched 60 000046 Records Changed 0 000047 Records Inserted 0 000048 Records Deleted 1 000049 000050 000051 000052 The following files are compared: 000053 000054 DDNAME DSN 000055 OLD => SYSUT1 AD1DEV.FMMVS90.DEMO.BASE.CUSTFILE 000056 NEW => SYSUT1N JOHSA08.FMMVS90.DEMO.BASE.CUSTFILE 000057 000058 Mismatched records (inserts, deletes, and changes) are reported. 000059 Record display is single record formatted with line(s) for each field. 000060 For changed records, only fields which are different are displayed. 000061 1CA File Master Plus V9.0 Page 2 000062 System CA11 2013-05-28 15:42 000063 000064 Compare Report Old File AD1DEV.FMMVS90.DEMO.BASE.CUSTFILE Key pos = 2 Key len = 7 000065 New File JOHSA08.FMMVS90.DEMO.BASE.CUSTFILE