Re: Secondary Keys

[Evan Harris <spanner@xxxxxxxxxx>]

I think he meant the user index object type. It's kinda like a user space 
except err... indexed.  My understanding is it's more or less a user space 
that also has an indexing capability and when you add records  to( via an 
API) it you specifiy how they are to be indexed. You can then retrieve them 
(again via an API) using the index you have defined.

I  suppose it ends up being like an array on steroids and as I understand 
it faster than keyed filed access.

No doubt someone will provide a better explanation and will clarify what I 
mean (and probably correct me)

Cheers
Evan Harris



>Dan,
>
>When you say "user index" are you talking about a work file with only the
>index? I think that will still cause to much of a delay when entering the
>application.
>
>Or maybe the light bulb just came on. Are you thinking of building the
>index in the morning and maintaining it along with the primary file
>throughout the day?
>
>Patrick Conner
>www.ConnecTown.com
>(828) 244-0822
>
>
>
> 
>
>                     D.BALE@handleman. 
 >
>                     com                      To: 
> RPG400-L@midrange.com
>                     Sent 
> by:                 cc:
>                     owner-rpg400-l@mi        Subject:     Re: Secondary 
> Keys
>                     drange.com 
 >
> 
>
> 
>
>                     12/06/00 10:58 
> AM
>                     Please respond 
> to
>                     RPG400-L 
 >
> 
>
> 
>
>
>
>
>
>It's been awhile, but I do not believe you can define a key field from a
>secondary file in a join logical.  My workaround for that has been to use
>OPNQRYF to do that, but that may not be practical for an interactive app.
>
>Another possibility for you is to load your data destined for your subfile
>into a user index and load the sorted data from there into the subfile.
>
>Dan Bale
>IT - AS/400
>Handleman Company
>248-362-4400  Ext. 4952
>
>-------------------------- Original Message --------------------------
>
>I have a maintenance program that can be displayed with multiple sorts. It
>is set up to read different a logical based on what the user keys as a sort
>code. However, some information in the subfile is from secondary files and
>they want the subfile sorted on those fields. I looked at doing a join
>logical, but I can't tell where I'm allowed to use the fields from the
>secondary file as key fields. Anyone have any suggestions?
>
>Patrick Conner
>www.ConnecTown.com
>(828) 244-0822
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>
>
>
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---