If you select the Verify Files Menu option on the Database Management menu, an overlay appears as shown in Figure 3-12 below. (This same overlay can also be called by the Verify Files Menu option on the System Administration File Management menu.)
Figure 3-12. Verify Files Menu Overlay
The utilities contained on the Verify Files menu are used to verify the structure and integrity of APPX data files. These utilities consist of:
· Verify Integrity of APPXIO Files by checking that the entire data file (extension of .dat) is readable and that each record in the file contains a matching record in the index file (extension of .key). If the file passes the integrity check, the file’s record count and pathname are displayed. Files that fail the check can be further analyzed by running appxI at the command line with a switch of “-an”. As the title implies, this option only works on APPXIO-format files (FMS type 1).
· Verify Data in Files checks each record in the file to ensure that the contents in each field meets the criteria of the field’s field type. This option can be used on any type of data file. Optionally, referential integrity can be verified by checking references to data lookups to ensure their files and keys exist. For each file with errors, an error log is created in your default print directory. When running this utility, the following options can be selected as shown in Figure 3-13 below:
· Include Referential Integrity Check? causes each field with a “Data Lookup” defined to be verified against the parent data lookup file. Records with field values not in the parent file will be reported.
· Report “Null” Data Lookup Values? If referential integrity check is selected, then this flag indicates whether null (blank) values will be validated against the parent data lookup file.
Figure 3-13. Verify Data In Files Options Overlay