Obtaining a random sample via p_ret_01
- Article Type: General
- Product: Aleph
- Product Version: 15.2
Description:
I would like to retrieve 100 records from our 01 library - but I was wondering, is there a way to get a random sample? Say, no parameters other than I know I want 100 records, and I know I want them to come from our bib library. Is there some trick to doing this with ret-01 or another service?
I know we can do it with SQL but it's a bit more time-consuming than a ret01 would be via the GUI. So I just wanted to see if it can be done in Aleph.
Resolution:
p_ret_01 doesn't have any facility for doing this.
You could do it like this:
SQL> select z00_doc_number || 'ABC01' from z00 where substr(z00_doc_number,7,3) = '000';
This will give you every 1000th number, with "ABC01" appended:
000001000ABC01
000002000ABC01
000003000ABC01
<etc.>
Then you can use this file as input to p_print_03 -- or some other print job.
- Article last edited: 10/8/2013