Subject: | |
From: | |
Reply To: | Grunwald, Wyell C. |
Date: | Wed, 8 Mar 2000 09:35:53 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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
|
|
|