RE: Secondary Keys -- RPG400-L

User Indexes are wonderful for small lists that don't change a lot, like
tables, but they have severe limitations.  If I recall correctly, it was
something like no more than 2,000 records of no more than 2,000 bytes each,
or something like that.  It might be ok for loading a subfile from if you
are not loading too many records at a time.

> -----Original Message-----
> From: Evan Harris [SMTP:spanner@ihug.co.nz]
> Sent: Wednesday, December 06, 2000 2:32 PM
> To:   RPG400-L@midrange.com
> Subject:      Re: Secondary Keys
> 
> 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
> +---


************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information 
which maybe confidential or privileged and is intended only for the individual 
or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the 
contents of this message. 
All personal messages express views solely of the sender, which are not to be 
attributed to Lincare Holdings Inc., and may not be copied or distributed 
without this disclaimer. 
If you received this message in error, please notify us immediately at 
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************
+---
| 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
+---