Number of records; export of bib records
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
Is there an easy way to view how many records we have?
I just need the final number, as I need to do a bib export, and the file I need to create can have no more than 90,000 records.
Resolution:
Assuming you are exporting all your abc01 bib records, I used the SQL in KB 16384-32946 to get a count:
abc01@ALEPH202> select count(*) from z13 where z13_title is not null;
**** Hit return to continue ****
COUNT(*)
----------
151355
151,355 is more than 90,000, so you need to:
1) run p_ret_01 to retrieve all record numbers from 000000001 to 000070000
2) run p_print_03 to output these records (using the file from step 1 as input)
3) run p_ret_01 to retrieve all record numbers from 000070001 to 999999999
4) run p_print_03 to output these records (using the file from step 3 as input)
- Article last edited: 10/8/2013