|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
