Mac, If the index value you are wanting to lookup is the exact value in the record you can use SELECTINDEX. However, you cannot do partial matches this way. For example, let's say you have an index on LAST.NAME in the CUST file, and you are looking for any records with the last name of TAYLOR...
OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST' SELECTINDEX 'LAST.NAME', 'TAYLOR' FROM F.CUST LOOP WHILE READNEXT CUST.ID DO ... REPEAT But if you wanted to get any cust record with LAST.NAME starting with "T". You cannot use SELECTINDEX and will have to query instead... OPEN 'CUST' TO F.CUST ELSE STOP 201,'CUST' EXECUTE 'SELECT CUST WITH LAST.NAME "T]"' CAPTURING OUTPUT LOOP WHILE READNEXT CUST.ID DO ... REPEAT Your only other option is to write logic that will query each individual part file and collate the results... Not a trivial routine. You might contact IBM/U2 Professional Services. Mark Baldridge wrote something that does this very thing and you probably can get it from them. Hope this helps some. Perry -----Original Message----- From: Mac Bhyat [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 7:21 AM To: Perry Taylor Subject: RE: [U2] Indexes on distributed files Hi, Thanks for the reply - do you know how I can use indexes on distributed files ? Thanks Mac -----Original Message----- From: Perry Taylor [mailto:[EMAIL PROTECTED] Sent: 22 March 2006 04:06 PM To: Mac Bhyat; [email protected] Subject: RE: [U2] Indexes on distributed files Unfortunately, BSCAN is not supported on distributed files in UniVerse. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: Wednesday, March 22, 2006 5:08 AM To: [email protected] Subject: [U2] Indexes on distributed files Hi, I having the following problem with indexes on a distributed file Scenario - I have a distributed file split by years - 1997 (1) 1998 = 2 1999 = 3.... I create an index on the main file, and build the index (this creates index files for each part file on the filesystem) Now i'm trying to do a bscan on the main file, using the USING clause (with the index I just created) and I'm getting a status error 3 - (file is not a type 25, or no secondary indices defined) The platform is Universe 9.6.2 - UNIX Can BSCAN's be done on a main controlling file for a distributed file, if so how ? Thanks Mac -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
