RE: Understanding User Indexes from RPG

What has motivated you to use User Indexes?  What benefit do they provide?

The ability to have a dynamically sized array of information that is indexed
and is faster to read/write to/from than DB2 tables (IBM's words, not mine).
LOT's of possibilities for usage (think eliminating "work files").

Note also that User Indexes can retain state across IPL's and can be saved
to tape.  I could see somebody extremely concerned about performance loading
DB2 lookup table data into User Indexes to gain that slight advantage.  I am
mostly theory now, but the better I understand them I can seem more uses.

HTH,
Aaron Bartell

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Joe D
Sent: Thursday, March 15, 2007 10:09 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Understanding User Indexes from RPG

----- Original Message -----
From: "albartell" <albartell@xxxxxxxxx>
Sent: Thursday, March 15, 2007 5:05 AM
Subject: Understanding User Indexes from RPG

So I have incorporated User Indexes (i.e. *USRIDX -
<http://tinyurl.com/yw8r4g> http://tinyurl.com/yw8r4g) into a handful of

Ok, I apologize in advance for what may seem like a silly question...

What has motivated you to use User Indexes?  What benefit do they provide?

Thanks,
JD