• 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