Example 1

Keywords › Keyword Descriptions › COMPREPORT › Example 1

Example 1

This example syntax produces the following report, in which all records processed are printed.

COMPARE,
  COMPREPORT(A)

Compare Report Old File CUSTOMER.OLDFILE Rec Length = 80 New File CUSTOMER.NEWFILE Rec Length = 80 Match pos ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 Old Rec #1 1 Intl Widget 534 Commerce Way Denver CO New Rec #1 Change pos ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 Old Rec #2 1 Acme Widgets 974 EZ Street Miami FL New Rec #2 1 Acme Widgets 1627 Helen Ave. Jupiter FL *************** ******* Delete pos ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 Old Rec #3 1 CT Widgets 8021 Hartford Blvd FarmingtonCT S U M M A R Y R E P O R T Old Records Read 3 New Records Read 2 Records Matched 1 Records Changed 1 Records Inserted 0 Records Deleted 1 | The following files are compared: DDNAME DSN OLD => SYSUT1 CUSTOMER.OLDFILE NEW => SYSUT1C CUSTOMER.NEWFILE All records on OLD and NEW files are reported with mismatches identified. Records are displayed in character format. For changed records, only lines that contain differences are displayed.

Example 2

This example syntax produces the following report, in which only mismatched, inserted, and deleted records are printed.

COMPARE,
COMPREPORT(M)

Compare Report Old File CUSTOMER.OLDFILE Rec Length = 80 New File CUSTOMER.NEWFILE Rec Length = 80 Change Old & New Record Length = 62 pos ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 Old Rec #2 1 Acme Widgets 974 EZ Street Miami FL New Rec #2 1 Acme Widgets 1627 Helen Ave. Jupiter FL *************** ******* Insert New Record Length = 62 pos ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 New Rec #3 1 MA Widgets Co. 981 Springfield Blvd Chicopee MA S U M M A R Y R E P O R T Old Records Read 2 New Records Read 3 Records Matched 1 Records Changed 1 Records Inserted 1 Records Deleted 0 The following files are compared: DDNAME DSN OLD => SYSUT1 CUSTOMER.OLDFILE NEW => SYSUT1C CUSTOMER.NEWFILE Mismatched records (inserts, deletes, and changes) are reported. Records are displayed in character format. For changed records, only lines that contain differences are displayed.

Example 3

This example syntax produces the following report, in which only a summary report is printed.

COMPARE,
  COMPPREPORT(S)

Compare Report Old File CUSTOMER.OLDFILE Rec Length = 80 New File CUSTOMER.NEWFILE Rec Length = 80 S U M M A R Y R E P O R T Old Records Read 2 New Records Read 2 Records Matched 1 Records Changed 1 Records Inserted 0 Records Deleted 0 The following files are compared: DDNAME DSN OLD => SYSUT1 CUSTOMER.OLDFILE NEW => SYSUT1C CUSTOMER.NEWFILE Only the summary report is written.