Previous Topic: Reviewing Protection for Data Sets

Next Topic: File History Search

File Comparison

When you review the production files of a data center, you can determine if two files are identical in certain respects. For example, suppose that you are reviewing a conversion of an accounts payable file to use the nine‑digit ZIP+4 codes. How do you know that the changes made to the file were limited to the ZIP code conversion? The programs can have overlaid another field by mistake or neglected to copy a field from the input record to the output record. A bogus company can be added to the master file.

If you assume that the file was converted with no errors, you might be correct. However, you do not know unless you actually compare both the old and new versions of the file. Of course, you could use the IBM IEBCOMPR comparison utility. It tells you that every record is different between the old and new files. However, you can also use the File Comparison display (6.4). It shows you the differences between the files in only the columns that you specify. You can ignore the columns that you expect to be different and concentrate on the ones that should remain unchanged.

You can also compare files in Endevor, CA Librarian, or CA Panvalet libraries with CA Auditor.