Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-12 Thread Oaks, Harold
Perry: In Universe the modifier SAMPLED nn selects every nn'th record. For example, SELECT MYFILE SAMPLED 50 selects every 50th record. That way you plow thru the entire file but come back with only 1/50 of the records. I don't know if this keyword exists in Unidata Harold Oaks Clark County,

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-12 Thread Bill Haskett
PM *Subject:* Re: [U2] [UV] Record Sampling for File Sizing Diagnostics Perry: In Universe the modifier SAMPLED nn selects every nn'th record. For example, SELECT MYFILE SAMPLED 50 selects every 50th record. That way you plow thru the entire file but come back with only 1/50 of the records. I

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Charles Stevenson
SAMPLED keyword with a D on the end will go thru the entire file. SAMPLED 1000 will get every thousandth record as it reads through the file. SAMPLED 1000 SAMPLE 2000 will do the same, but then stop after it builds a list of 2000. That is, after it's read thru the 1st 2 million keys. On Tue,

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Charlie Noah
Hi Perry, Does UV support SAMPLED? If so, use: SELECT file SAMPLE 300 SAMPLED where is the number of records to skip between sample IDs picked up. If it doesn't, you're probably going to have to write a little program. Regards, Charlie Tiny Bear's Wild Bird Store Home of

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Charlie Noah
I probably hit Send within milliseconds of you. :-) Charlie On 06-11-2013 11:15 AM, Charles Stevenson wrote: SAMPLED keyword with a D on the end will go thru the entire file. SAMPLED 1000 will get every thousandth record as it reads through the file. SAMPLED 1000 SAMPLE 2000 will do the same,

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Perry Taylor
Of Charlie Noah Sent: Tuesday, June 11, 2013 10:21 AM To: U2 Users List Subject: Re: [U2] [UV] Record Sampling for File Sizing Diagnostics I probably hit Send within milliseconds of you. :-) Charlie On 06-11-2013 11:15 AM, Charles Stevenson wrote: SAMPLED keyword with a D on the end will go thru