Posted by Barbara Brazil on April 21, 2014 at 15:26:33:
In Reply to: Some questions about E9A errors posted by Bob A on April 21, 2014 at 13:07:12:
Hmmm... After reading the code for CometEx's key check utility I can see that it probably doesn't do what you're expecting.
First, the E9A question... If you're using multi-keyed files, I would highly recommend you be on CometServices version 14.00. That version fixes a problem that could corrupt the header of the secondary key trees if a ClearFile is done or if you delete all the records from the file. This has nothing to do with KeyCheck as you'll see next.
The CometEx Key Check utility checks the key data in the record against the key data in the key tree. This is only done for the primary keys. So you see any corruption to secondary key trees is irrelevant for this utility. The old QTILITY Key Check also only checks the primary keys.
I think you're right on when you suspect the E9A is not reported by CometEx's utility because it is written using CometLib. Turns out the INQUIRE done there isn't checking for a fatal error returned. Oops. But then maybe that's a good thing because at least you do get some indication that something's wrong. The old QTILITY program is an IB program and it will blow up on the fatal error.
I haven't done any timing tests to compare Copy vs KeyBuild, but I'll bet Grant has!
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.