Thanks for all the responses that were sent to my original question.

I needed a way to alarm staff  when any of our detail sets were approaching
the HWM because we've enable HWMPUT which follows the HWM first and then
the delete chain.  We're doing this because we're starting an archive
process that runs everyday and we don't want our details to get real
fragmented and we're willing to waste a little disc space.

I used the following command in MPEX:

LISTF @.DATA.PROD(DBSETHIGHWATERMARK >= DBSETCAPACITY*.9   &
                   AND DBSETTYPE = "D")


Thanks again!

Rick Hohlbaugh




David Burney
                                                          Summit Racing
Equipment
[log in to unmask]
                                  http://www.summitracing.com

                                -------------------------------------------
                Instead of loving people and using things,
                people often love things and use people.
                                 ---------------------------------------
----
All opinions expressed herein are mine and in no way reflect those of my
employer.