I am not sure that Adager does do an unload and reload on a detail set.
I suspect it depends on the high water mark. If you shrink a detail set
to the high water mark using Adager I think it just changes a few bits
in the dataset. That's why Adager is so fast. It is also one of the
contentious issues regarding Adager.

Anyone from Adager like to comment on this?

Regards
John

--- Michael L Gueterman <[log in to unmask]> wrote:
> Tom,
>
>   Even with Adager for your Image dataset, you're
> essentially unloading
> and reloading that particular dataset to decrease
> the capacity (with
> some assumptions thrown in there :)  There are two
> Allbase utilities out
> there that perform "similar" types of functions:
>
> .  LeeTech's DB/Advisor for SQL
>    http://www.leetech.com
> .  Bradmark's DBGeneral/SQL (used to be
> Flexibase/SQL)
>    http://www.bradmark.com
>
> You can also simply do an 'Unload to external' in
> ISQL, drop and recreate
> the table (and associated information), then a 'load
> from external' to get
> your data back.  This will not be as quick as using
> a third party tool, but
> if you don't need to perform regular maintenance on
> the database, this
> method is very workable.
>
> Regards,
> Michael L Gueterman
> Easy Does It Technologies
> (LeeTech VAR)
> email: [log in to unmask]
> http://www.editcorp.com
> voice: (888) 858-EDIT -or- (509) 943-5108
> fax:   (509) 946-1170
> --
>
> -----Original Message-----
> From:   Tom Hula [SMTP:[log in to unmask]]
> Sent:   Thursday, July 08, 1999 6:40 AM
> To:     [log in to unmask]
> Subject:        [HP3000-L] ALLBASE table sizes
>
> If I want to change the size of a dataset in Image,
> I just get into
> Adager and change it.
>
> Is there any comparable way to DECREASE the size
> that an ALLBASE table
> is using, short of unloading all the data,
> recreating the database, and
> then reloading all the data?
>
> I have a 3rd-party ALLBASE database for one
> application that is taking
> up way too much space and I would like to cut down
> the size.  I have
> learned how to allocate more space when needed, but
> that is not the
> problem.
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com