Counting unique attribute values in a file

[SJman]

I need a dictionary, MD or VOC entry that will return the number of
times a particular values appears in a particular attribute or
dictionary item for a sort statement.
EX:
SORT FILE.NAME BY DICT.ITEM BREAK-ON DICT.ITEM TOTAL CNT ID-SUPP DET-
SUPP

Where the CNT is what I am looking for. I don't care whether it is a
DICT item, MD item or a VOC entry.

SJ

[Martin Phillips]

Hi,

I am guessing from the above that this is UniVerse, QM, or some other
Information style system.

Use an I-type
SUM(EQS(fieldname, REUSE("value")))
where fieldname is the name of the multivalued field to be processed and
value is the value you want to count.

Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200