Finding bib records with multiple occurrences of field

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

Description:
How can I find bib records with multiple 949 fields (or multiple occurrences of some other field)?

Resolution:
If you have the z00r, SQL will give you this. Here's a search for multiple 949 fields:

abc01@ALEPH20> select Z00R_DOC_NUMBER from z00r where z00r_field_code like '949%' group by Z00R_DOC_NUMBER having count(*) > 1 order by Z00R_DOC_NUMBER;

• Article last edited: 12-Mar-2016