Like someone else said, with Adager et al, you can do it easily.
Yes, the Automatic Master would be set up with all the detail key
entries. This by far the easiest but not infallible - IN ALL CASES, DO A
BACKUP (DBSTORE or equiv.)
With Suprtool, do a complete unload of all Details and Manual Masters to
flat files, then delete the database and rebuild it using the new schema
with the additional Automatic Master and path. Then, use Suprtool to
reload the database. This all assumes no changes in the schema other
than adding a key designation to an existing item and adding the
corresponding Automatic Master.
This general method, like with Adager, etc. can do lots of other schema
changes as long as the sets being loaded correspond byte by byte to the
Detail or Manual Master record being reloaded, including any changes.
The advantage of Adager etc. is that they will also manage the byte by
byte changes and you won't have to deal with all the flat files.
Without one of those tools, you will need to do a DBUNLOAD of the entire
database to tape, delete the database, create the database with the new
schema AS THE LAST DATASET, and load the database with DBLOAD. The new
Automatic Master MUST be the last Dataset to be defined, since DBLOAD
depends on dataset number, not name. The DBLOAD might report an error
when it finds the new Automatic Master, but since it doesn't
specifically load an A-Master, it might not care. See the reference
manual to see what changes are supported. Some changes cannot be done
this way and programmatic (i.e. Suprtool or COBOL/C/Pascal/RPG/Fortran)
must be used for the unloads and the loads.
Good luck.
Dennis Hassell
(941) 750-9917 - home
(941) 224-3981 - cell
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Rao, Raghu
Sent: Tuesday, February 04, 2003 9:40 AM
To: [log in to unmask]
Subject: [HP3000-L] Changing a field as KEY item
Hi,
I have a DETAIL dataset (with 26 fields in it) which has its 4 key items
associated with Automatic Masters. I would like to add 5th item from
this dataset also to be associated with another new Automatic Master (or
may be Manual Master). How do I accomplish this ? What do I have to do
get this done ?
Does redefining the field into Key item associated with Automatic Master
automatically add all those entries into the Master ?
Any help is kindly appreciated.
Thanks.
With Best Regards
Raghu. Rao
Ph: 1-800-933-3920 Ext. 755 or 585-327-5755 (direct)
Fax: 585-327-5702
Email: [log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
Sing the new scche
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
