On Wed, 8 Mar 2000 09:25:34 -0500 , bill grefe <[log in to unmask]>
wrote:

>I have an image data set(see below). I would like to have this data returned
>from image sorted by
>Catalogue-number regardless of the search path used to find the data.  The
>programs that use this
>Data set are supplied by a third party and I have no access to them.
>Can I a) add a sort path with adager to catalogue-number (without breaking
>anything) or
>          b) sort the data with adager periodically (I used to do this with
>DBMGR reload along time ago
>but I think they "enhanced" reload so the order of the non sorted search
>paths weren't changed).

Well I've seen some possible solutions to your problem ... but I'd
like to ask something nobody else has ... "why"? There may be more
than one way to skin this particular cat (apologies to any SPCA
members offended by this cliche) ... perhaps there are alternatives to
sorting the actual dataset that are less painful or more efficient.

So ... WHY do you want to have the entries come out of the DB in this
particular order?