• Article Type: General
• Product: Aleph
• Product Version: 20

Desired Outcome Goal:
Find all the bib records connected to a particular authority record (-- not just the records linked to a particular heading, but the records linked to *any* of its headings).

Procedure:
Method 1: Bring up each heading in the xxx01 GUI, go to the # of Docs column, and click on "Show".

Method 2:

> s+ xxx01
> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ Z02_doc_number from z01, z02 where substr (z02_rec_key,1,9) = z01_acc_sequence and Z01_REC_KEY_4 = 'XXX10' || '000029538';

<where 'xxx01' is the bib library, 'XXX10' is the authority library, and '000123456' is the authority record number.>

Category: Cataloging (500)

• Article last edited: 11/13/2014