Hi,

Timothy Hoefner wrote:
>
> My question is simple but I've got to have the correct answer
> so that I may or may not win an argument with our DBA.
>
> Is it possible to programmatically delete automatic masters
> without deleting the associated details?


It's possible with a tool like MPEX, which doesn't care (sic)
what the file type is, and assumes that *you* know what you're
doing when you purge one of *those* files!

Another way around this is to RESTORE just the datasets that
you need for any particular program, including the root file
(required), the detail(s) accessed, and the masters for the
chain(s) being read.  Our operator does this occasionally
when nightly or monthly reports must be re-run from a prior
database.  Works fine.  Lasts long time.  (c) Denys Beauchemin?

But then again, those two 'solutions' don't answer your original
question: 'Is it possible to >programmatically< delete automatic
masters...'  Oh well.

HTH!

 +-------------------------------------------------------------------+
  My mind is my own, as are my ideas and opinions.
  My heart, body, and soul, however, all belong to others.       Tim.
 +-------------------------------------------------------------------+
  Tim Ericson            tericson      DenKor Dental Management Corp.
  Sr. Systems Analyst     at denkor    503-526-4440 (my direct number)
    (& Systems Manager)     dot com         http://www.denkor.com
  Programming HP3000s since 1983!      Quality dental care since 1970!
 +-------------------------------------------------------------------+
  UDCs and Command Files:  http://www.denkor.com/hp3000/command_files
 +-------------------------------------------------------------------+