Think of the index as a file.  If you want to read all entries one option is to 
create a loop, use the first option on the first read and with that key use the 
greater than option for subsequent reads.  The pieces are there you just need 
to manipulate them to suit your needs.

I would need to double check but I believe you can retrieve multiple entries at 
once.  This will cut down on the number of reads.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Gauri Kulkarni
Sent: Monday, April 18, 2005 6:41 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: User Index

Yes .. right.
I also got the parameters for this.

Now, I have moved some records to USER INDEX and want to retrieve all the
records thru QUSRTVUI.
No search type provides the way to get all the records. (Search type (input,
4 bytes, binary)--the type of search to perform. Valid values: 1 = equal; 2
= greater than; 3 = less than; 4 = greater than or equal; 5 = less than or
equal; 6 = first (the first entry in the user index); 7 = last (the last
entry in the user index); 8 = between)

How can I use between if i want to?
Or is there anything else to get all the records ?

Thanks and Regards,

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of HauserSSS
Sent: Saturday, April 16, 2005 4:07 PM
To: RPG programming on the AS400 / iSeries
Subject: AW: User Index


there are a couple of APIs to handle User Indexes:
  Add User Index Entries (QUSADDUI)
  Create User Index (QUSCRTUI)
  Delete User Index (QUSDLTUI)
  Remove User Index Entries (QUSRMVUI)
  Retrieve User Index Attributes (QUSRUIAT)
  Retrieve User Index Entries (QUSRTVUI)

Just look at the decriptions in the online library:


-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Gauri Kulkarni
Gesendet: Freitag, 15. April 2005 09:35
An: 'RPG programming on the AS400 / iSeries'
Betreff: User Index


I am trying to create a user index thru 'QUSCRTUI' which is handled in my
RPG program.
I could create the index but dont know how to write and retrieve the records
thru the RPG
Can Anybody help me doing this?

Also, if the user index exists, i had to delete it and create the new one
for new data. Is there any pgm or something which will help to CLEAR the
user index instead of deleting and creating it again ?

Thanks and Regards,
World-Wide Partnerships. World-Class Solutions.

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete  this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at netadmin@xxxxxxxxx and delete this mail.

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page