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 data file used.

<Key item>: Optional character string (with or without quotes)

Name of key item used to perform the statistical calculation. 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.