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.