DOH!
     __&__
    /     \
   |       |
   |  (o)(o)
   C   .---_)
    | |.___|
    |  \__/
    /_____\
   /_____/ \
  /         \
thanks.

> -----Original Message-----
> From: Wyell Grunwald [mailto:[log in to unmask]]
> Sent: Wednesday, May 07, 2003 8:58 AM
> To: [log in to unmask]
> Subject: Re: Image schema tricks?
>
>
> NO NO
>
> If you have Adager, they have the ability to sort these.  See
> this sample text:
>
> Database [NO MORE] ?GHP
> IMAGE/SQL Database GHP.PDATA.AIHTEST: Consistency checking
>
> Checking 391 data items ...
> Checking 39 datasets ...
>
> This database uses:
>   Dynamic DETAIL dataset expansion DDX
>   Master datasets INDEXED by B-Trees
> Database GHP.PDATA.AIHTEST.  Adager command [EXIT] ?ITEM SHUFFLE
> Adager Function: Shuffle Item
>
> REMINDER:  This operation implies renumbering of DataItems.  Please
>            update all programs (if any) that use DataItem NUMBERS.
>
>
> ItemShuffle on database GHP.PDATA.AIHTEST, which has 391 items.
>
> =====================================================================
> Answer with a given DataItem to relocate THAT specific DataItem.
>
> Answer "@" to SORT all items by their names (in ascending order).
> =====================================================================
>
> DataItem (enter "@" for "all") [NO MORE] ?@
>
> I am preparing 391 DataItems in database GHP.PDATA.AIHTEST for
> sorting according to their names.  I must update every dataset and
> every path in the database (in addition to updating every DataItem),
> because the database's tables use DataItem NUMBERS, which will change.
> WED, MAY  7, 2003, 11:56'21 AM
>
> I have scheduled the 391 DataItems for sorting by DataItem name.
> WED, MAY  7, 2003, 11:56'28 AM
> ---------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> REMINDER:  I will NOT change the database in this run.  To
> implement your
> changes, you MUST stream the resulting StreamFile.
> ---------------------------------------------------------------------
>
> At this point you may exit, leaving your database unchanged;
> or you may specify
> more Adager commands; or you may schedule the specified changes:
>
> Database GHP.PDATA.AIHTEST.  Adager command [SCHEDULE CHANGES] ?
>
> Just use that !  No fuss, no mess, easy as pie !
>
>
>
> [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
> []
> []   Wyell Grunwald
> []   Senior Technical Analyst
> []   Geisinger Health System
> []   Information Technology
> []   Mail Code 30-33
> []   100 North Academy Avenue
> []   Danville, Pennsylvania  17822
> []   Phone:  570-271-7342
> []   Fax:  570-271-5162
> []   e-mail:  [log in to unmask]
> []   Web:  www.geisinger.org
> []
> [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
>
> >>> Tracy Pierce <[log in to unmask]> Wednesday, May
> 07, 2003 10:57:16 AM >>>
> 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 *