cmpdict Output

The output of a cmpdict command can be redirected to an ascii file and then imported into a spreadsheet. The format of the cmpdict command output depends on which type of database object is being compared:

File Database Object (FILE)

The following example shows the columns written by cmpdict when the database object being compared is a file in the database.

Note: The first row shown in this example is not written by the utility; it is provided for the sake of explaining the output more clearly. 
SystemCode   FileName   Subject  Action   SqlName   View
AR           ARISGBLK   FILE     DELETE
SY           DATECOLS   FILE     NEW
AR           ARISGBLK   FILE     CHANGE             ISVIEW
HR           L_HEMP     FILE     NONE

The following table describes the output.

Column Description Explanation
1 SystemCode The system code in which the file exists.
2 FileName The name of the file being compared between data areas.
3 Subject The type of database object being compared. In this case, FILE.
4 Action

The type of difference in the database object between the source and destination data areas:

  • NEW

    Indicates that the database object is new in destination data area.

  • DELETE

    Indicates that the database object exists in the source data area, but not in the destination data area.

  • CHANGE

    Indicates that the database object is different in destination data area.

  • NONE

    Indicates that the database object is identical in both data areas.

5 SqlName For future implementation.
6 View If the file is a view, the phrase IsView will appear.

Index Database Object (INDEX)

The following example shows the columns written by cmpdict when the database object being compared is an index.

Note: The first row shown in this example is not written by the utility; it is provided for the sake of explaining the output more clearly. 
SystemCode   FileName    Subject  Action   Name       SqlName  Unique
AR           AROITEMS    INDEX    DELETE   AROSET10
PR           TIMERECORD  INDEX    NEW      TRDSET10
PR           TIMERECORD  INDEX    CHANGE   TRDSET11
PR           TIMERECORD  INDEX    PRIMARY  TRDSET12

The following table describes the output.

Column Description Explanation
1 SystemCode The system code in which the file exists.
2 FileName The name of the file being compared between data areas.
3 Subject The type of database object being compared. In this case, INDEX.
4 Action

The type of difference in the database object between the source and destination data areas:

  • NEW

    Indicates that the database object is new in destination data area.

  • DELETE

    Indicates that the database object exists in the source data area, but not in the destination data area.

  • CHANGE

    Indicates that the database object is different in destination data area.

  • PRIMARY

    Indicates that the database object became the primary index in the destination data area.

5 SqlName For future implementation.
6 Unique Whether the index is unique or not.

Field Database Object (FILEFIELD)

The following example shows the columns written by cmpdict when the database object being compared is a field in a database file.

Note: The first row shown in this example is not written by the utility; it is provided for the sake of explaining the output more clearly. 
SC FileName   Subject   Action Pos   Ref-Fld-Name Name         Occ Type   Prec Scale
AR AROITEMS   FILEFIELD CHANGE                    DISC-PCT     3   Percent    5    5
LA CKPOINT    FILEFIELD CHANGE                    RESTART-INFO 1   AlphaLower 691  0
PR TIMERECORD FILEFIELD CHANGE                    WAGE-AMOUNT  1   Signed     11   2
AR AROITEMS   FILEFIELD DELETE                    INVOICE
HR EMPLOYEE   FILEFIELD NEW    AFTER ZIP          COUNTRY

The following table describes the output.

Column Description Explanation
1 SystemCode The system code in which the field exists.
2 FileName The name of the file being compared between data areas.
3 Subject The type of database object being compared. In this case, FILEFIELD (a field in a file).
4 Action

The type of difference in the database object between the source and destination data areas:

  • NEW

    Indicates that the database object is new in destination data area.

  • DELETE

    Indicates that the database object exists in the source data area, but not in the destination data area.

  • CHANGE

    Indicates that the database object is different in destination data area.

5 Position

The location of the field in the file, when the field is new or the change is that the field moved within the file:

  • BEGIN

    Indicates that the field is at the beginning of the file in the destination data area.

  • END

    Indicates that the field is at the end of the file in the destination data area.

  • AFTER

    Indicates that the field follows the Ref-Field-Name field in the destination data area.

7 Ref-Field-Name A field used to indicate the position of another field in a file.
8 Name The name of the field being compared.
9 Occ The number of times the field occurs.
10 Type The datatype of the field listed in column 8.
11 Precision The precision of the field listed in column 8.
12 Scale The scale of the field listed in column 8.

Index Field Database Object (INDEXFIELD)

The following example shows the columns written by cmpdict when the database object being compared is an index field.

Note: The first row shown in this example is not written by the utility; it is provided for the sake of explaining the output more clearly. 
SystemCode IndexName Subject    Action Position Ref-Field-Name Name SqlName Direction
PR         TRDSET6   INDEXFIELD MOVE   AFTER    PROCESS-GRP    TIME-SEQ
AR         AROSET1   INDEXFIELD NEW    AFTER    TRANS-TYPE     INVOICE

The following table describes the output.

Column Description Explanation
1 SystemCode The system code in which the index field exists.
2 IndexName The name of the index being compared between data areas.
3 Subject The type of database object being compared. In this case, INDEXFIELD (a index in a file).
4 Action

The type of difference in the database object between the source and destination data areas:

  • NEW

    Indicates that the database object is new in destination data area.

  • DELETE

    Indicates that the database object exists in the source data area, but not in the destination data area.

  • CHANGE

    Indicates that the database object is different in destination data area.

5 Position

The location of the field in the file, when the field is new or the change is that the field moved within the file:

  • BEGIN

    Indicates that the field is at the beginning of the file in the destination data area.

  • END

    Indicates that the field is at the end of the file in the destination data area.

  • AFTER

    Indicates that the field follows the Ref-Field-Name field in the destination data area.

7 Ref-Field-Name A field used to indicate another field in the index.
8 Name The name of the index field being compared.
9 SqlName For future implementation.
10 Direction Whether the index field has changed from ascending to descending, or vice versa.

Index Condition Database Object (INDEXCOND)

The following example shows the columns written by cmpdict when the database object being compared is an index condition.

Note: The first row shown in this example is not written by the utility; it is provided for the sake of explaining the output more clearly. 
SystemCode IndexName Subject   Action  Name
PR         TRDSET4   INDEXCOND CHANGE  SOMECONDNAME

The following table describes the output.

Column Description Explanation
1 SystemCode The system code in which the index condition exists.
2 IndexName The name of the index where the condition exists.
3 Subject The type of database object being compared. In this case, INDEXCOND (a condition in an index).
4 Action

The type of difference in the database object between the source and destination data areas:

  • NEW

    Indicates that the database object is new in destination data area.

  • DELETE

    Indicates that the database object exists in the source data area, but not in the destination data area.

  • CHANGE

    Indicates that the database object is different in destination data area.

8 Name The name of the condition being compared.