If your record key is comprised of something meaningful you might want to query against it. For example if your key is say STATE: '*': CITY and you want all the records for a given state ... SELECT FILE WITH @ID "FL*]" .
Perry -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 8:52 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? Maybe I am missing something, but why would you want an index on @ID? JRI -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:18 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? YUP. I just isolated it to the index of @ID. I changed the original filename, recreated a new file Copied all the data Copied all the dict And finally, recreated the index (@ID) Testing the sampling on each step, all went well until I recreated the index, then it bombed again. And yes, using the NO.INDEX does fix it. Does working with an active select list de-activate the @ID Index? George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Daniel McGrath Sent: Friday, May 24, 2013 10:10 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? George, I checked out system and we have experienced this issue before. Check if you have built an index on @ID. If you have, this is what is causing your issue. Using the NO.INDEX keyword will give you correct results. I don't have an explanation for the behavior. Let us know how it goes. Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: Friday, May 24, 2013 7:52 AM To: U2 Users Subject: [U2] UV File doesn't like being sampled? OK. Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the SELECT still returns the entire file, However, if I use the SAMPLE modifier in a LIST command on that same file, it only returns the sample amount. Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it returns the whole file as an active list, and if I Do another SELECT with the SAMPLE modifier on that active list, it only returns the the sample amount. So what, the file is just toying with me? I guess if I really want that sample, I have to ask twice? >SELECT FILENAME SAMPLE 10 929347 record(s) selected to SELECT list #0. >>SELECT FILENAME SAMPLE 10 10 record(s) selected to SELECT list #0. >> This seems to be the only file that is behaving this way. There are no dictionary items in the file that would Interfere with the UV selection. My next step will be to create a new file, and copy over the contents, just in case there is something that Is corrupted in the file. This is on UV 10.0.2 / RH Linux _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users 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] http://listserver.u2ug.org/mailman/listinfo/u2-users
