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. Rick -----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. Thanks. 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, Gauri. -----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 Hi, 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: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/ rzahgmtu.htm Birgitta -----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 Hello, 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 program. 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, Gauri. http://www.patni.com 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 mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact