Re: Random Records

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Camille

You might try the rand() function. Something like

select * from file where rrn(file) = int(rand() * nbrrcds)

You could do a range with 2 calls to rand() in the same select, using the
between predicate.

You end up with no records if the RRN points to a deleted record, or
multiple records. The rand() is run for each record in the file.

If you specify a seed with rand(seed), you get the same sequence of random
numbers.

I tried something with max(rrn(file)), but it is not allowed.

HTH

Vern

At 10:43 AM 11/18/02 -0500, you wrote:
> This is a multi-part message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> We are looking to read random records in a file on the 400 via an ODBC
> connection using a sequel statement.  Is there an  SQL Statement to get
> the Random Number of Record Sets.  Thoughts and suggestions would be
> appreciated.  Thanks, Camille Brown