Tracy,
Since you have Adager, there is a shuffle items command. However, any application that uses item
numbers instead of item names will have to be fixed. Omnidex for example. We also use Bridge, an
add-on to Netbase.
We have an in-house data base where I shuffle the items whenever we add new ones (frequently). The
Omnidex and Netbase fixes are relatively easy to implement. In addition to shuffling items, I add
sets in alphabetical order, grouped by M, A and D.
Leonard
--
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-1955
pager: 781-226-2431
Tracy Pierce
<tracy.pierce@sbc To: [log in to unmask]
global.net> cc:
Sent by: HP-3000 Subject: [HP3000-L] Image schema tricks?
Systems
Discussion
<[log in to unmask]
TC.EDU>
05/07/2003 10:57
AM
Please respond to
tracy.pierce
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 *
|
