Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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
    • Was this article helpful?