Kbase P100079: Why isn't dbtool and dbanalys consistent when reporting number of records for a table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/13/2005 |
|
Status: Verified
GOAL:
Why does dbtool report one more record than the output from dbanalys?
GOAL:
Why doesn't dbtool report the same number of records as dbanalys?
GOAL:
Why doesn't a record count against a table match the record counts reported by dbtool?
FIX:
The dbtool utility performs validation of not only records associated with a table, but validation is also performed against the template record for the table as well. The template record is a record for the table which is used to reference all fields and their initial values for a table. This record is referenced in the metaschema in the _Template file. The template record is NOT included in the indexes associated with the table so it doesn't show up when performing a for each. For more information on how to locate the RECID associated with the template record, see solution: P105275, "How to find the RECID of the template record for a given table?"