HP3000-L Archives

March 2000, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Grunwald, Wyell C." <[log in to unmask]>
Reply To:
Grunwald, Wyell C.
Date:
Wed, 8 Mar 2000 09:35:53 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (50 lines)
Certainly !  Just add the sort with ADAGER.  Since the sorted item
(Catalogue-number) is already a search item, this is not a problem.  If
Catalogue number was not a search item, this would be a problem because any
change programmatically to the catalogue number would require a put / delete
or critical item update.  Since this is already the case, adding a sort will
not cause a problem.  Beware that if you add the sort to all three items
below, that your performance on puts is going to slow way down if you have a
large number of detail dataset entries.

> -----Original Message-----
> From: bill grefe [SMTP:[log in to unmask]]
> Sent: Wednesday, March 08, 2000 9:26 AM
> To:   [log in to unmask]
> Subject:      sorting image data
>
> 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).
>
> SET NAME:
>    BROWSE-DETAIL,DETAIL
>
>       ITEMS:
>          CATALOGUE-NUMBER,     U20           <<SEARCH ITEM>>
>          CLASS,                U6            <<SEARCH ITEM>>
>          SUBCLASS,             U6            <<SEARCH ITEM>>
>          CATEGORY,             U10           <<SEARCH ITEM>>
>          TYPE,                 U4
>
>       CAPACITY: 8320            ENTRIES: 8198
>
>
> Thanks,
>
> William Grefe
> [log in to unmask]
> PCI-WEDECO Environmental Technologies, Inc.
> phone: 973-575-7052
> fax: 973-575-8941

ATOM RSS1 RSS2