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