IIRC the root file also maintains current internal pointers to the
datasets, so a swap would disrupt the root and dataset relationship.
Also, I think the item numbers are referenced both in the sets and the
root - messing with the root would throw off these pointers. This is in
addition to the numbers possibly being referenced in the applications.

Somebody who has root file experience might know for sure - Alfredo??

Dennis Hassell
Dennis Hassell and Associates
(941) 746-4919
(941) 224-3981 - cell



-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Tracy Pierce
Sent: Wednesday, May 07, 2003 10:57 AM
To: [log in to unmask]
Subject: [HP3000-L] Image schema tricks?


I have an Image database in which the item declarations have been added
willy-nilly, and now I'd like to sort those declarations for easier
readability without breaking my database and without doing a reload.

1) generate a schema from the live base via adager
2) sort the item declaration list as desired
3) chgroup newbase
   file dbstext = schemafrom1)
   file dbslist = $stdlist
   run dbschema.pub.sys;parm=3
   echo create vmsdb > dbuinput
   echo exit        >> dbuinput
   run dbutil.pub.sys;stdin=dbuinput
4) now can I safely just swap the new root file into place?  (no, I
never use numbers for either sets or items, but will this break things
if I do so
later?)


Tracy Pierce

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *