Application database compare
This utility may be useful after a RESYNC to populate a new version of the database. Each record is read sequentially from the TODB and a random read is made to the FROMDB. While this method is generally sufficient to detect any differences between the two files, it does not detect a record in the FROMDB that is not in the TODB. You can run the comparison both ways to be absolutely certain all differences are discovered.
All application information record (DBI) fields are compared except date of last use and creation date. These fields are updated on a RESYNC if the budget application is updated. The format of the COMPARE statement follows and each keyword is explained below.
COMPARE TODB(sequential-read-db)
Keyword | Description |
|---|---|
FROMDB(random-read-db) | This required keyword specifies the input database to be read randomly. |
TODB(sequential-read-db) | This required keyword specifies the input database to be read sequentially. |
The following example illustrates a COMPARE function in which two databases are compared.
COMPARE TODB(EMP.SGC.TEST)