Maybe I am missing something, but why would you want an index on @ID? JRI
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
