How can we get counts of bib, item and authority records?
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
How can we get counts of bib, item and authority records?
Resolution:
**For bib records:**
1. util h/1/10 ("Z0102 Setup") gives the number of records in each bib library and in each logical base. You can choose a base which excludes deleted or suppressed records, as desired.
2. The following SQL gives a count of non-deleted bib records (records with a non-null z13_title):
> s+ abc01
> select count (*) from z13 where z13_title is not null;
> quit
**For items:**
> s+ abc50
> select count(*) from z30;
> quit
**For authority records:**
1. If you specify the xxx10 as a base in tab_base.eng, you can use util h/1/10 to get a count, as described above for bib.
2. The following SQL gives a count of non-deleted authoriyt records (records with a non-null z13_title):
> s+ abc10
> select count (*) from z13 where z13_title is not null;
> quit
If you get "No rows found" for the authority, then you apparently don't have the z13 built there. In that case, query the z00 instead:
> s+ abc10
> select count (*) from z00;
> quit
- Article last edited: 6/23/2015