Paolo Tealdi <[log in to unmask]> wrote:
>I've a database on Turbo Image (i'm new with this database ...)
>i have to put a new field in an existing table. No problem !
>i put it at the end of the table and do an DBUNLOAD-DBLOAD.
>Now I have to index this new field. How can i do ?
>I can't put the AUTOMATIC MASTER at the end of the DBSTEXT ,
>because when DBSCHEMA finds the definition it just send me an error
>because there isn't (still) a relation with an AUTOMATIC.
>I can't put before the incriminated table because DBLOAD
>gets angry and do pitoresque things!
>I think that there must be a solution, and simple, but i can't
>find it. :-((
>Anybody can help me ?

IMAGE requires that a master set be defined in the schema file
prior to any detail sets which it serves as a key.  You should
be able to DBUNLOAD the base, insert the set in the schema in
the proper place and re-build the base, then DBLOAD it without
any problems.

The UNLOAD/LOAD technique provided by HP requires that items be
added to the end of existing datasets.  However, it places
dataset information in the data it unloads from the base so it
can place the data back in the same set when doing the load.
As such, there shouldn't be any problem inserting a new set to the
base providing its is a new name.  And because it is an auto-
master, when the entries are placed in the corresponding detail
during the DBLOAD, the search paths will also be established
for the new auto-master.

By the way, you need to be sure and have a backup of your base
before performing this, or any other changes just in case the
unthinkable happens and you need to recover your database.

Using this technique to change a database can easily be quite
painful, as the entire base is unloaded and reloaded. Depending
upon the size of the base, this can take quite some time!  Also,
if tape is used you're subject to the risk of having a bad
tape and thus not being able to successfully reload the base.

Most shops utilize a database tool to help facilitate changing
a database.  These tools tend to surgically perform only those
changes needed without disturbing other aspects/areas of the
database, therefore performing these types of changes in
much less time and in most cases, much safer than a complete
unload/reload.

The available tools, while offering similar features, do not
all operate the same.  Some have limitations which may or may
not apply to your case, such as not supporting certain new
IMAGE features.  The current major list of database mgmt tools
are:

<plug-alert>
       DBGENERAL    -  Bradmark Technologies (free demo available)
<end-plug>
       ADAGER       - Adager Corporation (free demo available)
       DBChangePlus - Hewlett-Packard (demo ?)
       FLEXIBASE    - Proactive/JetForm (primarily available in Europe)
                                        (demo ?)

There are others as well, but those listed above tend to be the
most widely used.  You may want to contact the vendors and obtain
information/a demo and look at what they offer and whether or not
it will help meet your needs.



/jf
                              _\\///_
                             (' o-o ')
___________________________ooOo_( )_OOoo____________________________________

                        Tuesday, February 3rd

___________________________________Oooo_____________________________________
                            oooO  (    )
                           (    )  )  /
                            \  (   (_/
                             \_)