- 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).
Method 1: Bring up each heading in the xxx01 GUI, go to the # of Docs column, and click on "Show".
> 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