Skip to main content
ExLibris
Ex Libris Knowledge Center

How to output list of preferred headings for particular authority library

 

  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

 

Question    
What is the best way to produce a list of the preferred terms in an (xxx11) Subject authority file? (print-03 for the z01 table is unsatisfactory since includes columns from the record besides the subject heading itself.)

 

Answer    
There's no Aleph Service which will produce a list of preferred headings for a particular library, but the following SQL should do that: 
SQL> select z01_rec_key, z01_display_text from z01 where z01_acc_sequence_see = '000000000' order by z01_rec_key ; 

Note: The "where z01_acc_sequence_see = '000000000'" is necessary so that that only preferred headings are included (-- and "SEE" references are excluded).

 


  • Article last edited: 02-Mar-2016
  • Was this article helpful?