Data Compare Report

carcudb2
The Data Compare Report displays all the differences between the two sets of data being compared. The following sample of an online report shows the changes that result from comparing the source table PDJIMB.EMP3 and the target table PDJIMB.EMP4. The labels for the types of changes are highlighted.
 RUDCRPT        --------- RC/Update Data Compare Report --------   COMMAND ===>                                                  SCROLL ===> PAGE                                                                                    SSID: D81A ------------------------------------------------------ USER3     >                                                                                      SOURCE DATASET: PDJIMB.EMP3                                                      TARGET DATASET: PDJIMB.EMP4                                                                                                                                       TYPE ORD COLUMN             DATA                                                 PAIRED INSERT/DELETE                                                             SRC     EMPNO               000020                                                       FIRSTNME            RONNIE                                                       MIDINT                                                                           LASTNAME            VANZANT                                                      WORKDEPT            B01                                                          PHONENO             3476                                                                                                                                TRG     EMPNO               000020                                                      FIRSTNME          =>BILLY                                                       MIDINT                                                                          LASTNAME          =>POWELL                                                      WORKDEPT            B01                                                         PHONENO             3476                                                ------------------------------------------------------------------------------- NON-PAIRED DELETE                                                               SRC     EMPNO               000020                                                      FIRSTNME            MICHAEL                                                     MIDINT              L                                                           LASTNAME            COOK                                                        WORKDEPT            B01                                                         PHONENO             3476                                                                                                                                ------------------------------------------------------------------------------- NON-PAIRED INSERT                                                               TRG     EMPNO               000001                                                      FIRSTNME            JIM                                                         MIDINT              Q                                                           LASTNAME            SHORTS                                                      WORKDEPT            AAA                                                         PHONENO             0666                                                                                                                                RC/UPDATE DATA COMPARE STATISTICS SUMMARY                                          NON-PAIRED INSERTS:            1                                                NON-PAIRED DELETES:            1                                                PAIRED INSERTS/DELETES:        1                                             ******************************** BOTTOM OF DATA *******************************
Viewing the Data Compare Report
Use the F7 and F8 keys to move through the report. If the columns extend beyond the right hand side of the screen, use the F10 and F11 keys to move horizontally in the report. When finished viewing the report, press F3 (End) to return to the Data Compare Explode Options screen.
Printing the Data Compare Report
Use the PPRINT, QPRINT, PFILE, or QFILE commands to print the Data Compare report or save it to a data set.
Data Compare attempts to recognize updated rows and marks them as CHANGED. Due to the nature of the algorithm being used, updated rows may get posted as INSERT/DELETE pairs.
The following table describes what updates to the target table look like:
Source
Key
Data
Source
Key
Data
aaaa
xxxxxxxxxx
Not Applicable
aaaa
xxxxxxxxxx
Not Applicable
bbbb
xxxxxxxxxx
Not Applicable
aaaz
xxxxxxxxxx
Not Applicable
cccc
xxxxxxxxxx
Not Applicable
bbbb
@@@@@@
Not Applicable
dddd
xxxxxxxxxx
Not Applicable
cccc
xxxxxxxxxx
Not Applicable
Not Applicable
Not Applicable
Not Applicable
dddd
xxxxxxxxxx
Not Applicable
A row with aaaz has been inserted and the row with key bbbb has had its data updated. Data Compare will say that two rows have been inserted (keys of aaaz and bbbb) and one row has been deleted (key of bbbb).