• 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