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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: 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

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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to