Number of duplicates found. Corresponds to the hInvalidRecNum constant if:

the statistics have never been calculated for the specified item.

the statistics are not supported by the specified type of item. HFSQL allows you to perform statistical calculations on key items only.

<Source>: Type corresponding to the specified source

Name of the data file used.

<Key item>: Optional character string

Name of the key item used to calculate statistics. If this name is not specified, <Source>.StatNbDuplicates will use the last item used by the last HFSQL management function (function starting with "H").

In the HFSQL Classic data files, the statistical calculations can only be performed on key items.

The number of duplicates corresponds to the total numer of entries less the number of distinct values. For example, if the entries are the numbers: 1, 3, 3, 5, 5, 5, 6, 7, 7, 7, 8, 9, then the number of duplicates is 12-7 = 5.