• 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