How to find records with multiple 090 fields
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We would like to get a list of Bib records that have 2 or more 090 tags. We've used the p_ret_01 service to find records with both 050 and 090, and other 09x tags, but we're stumped on how to find multiple 090's.
If anyone has a method, either by a Retrieve service, or by SQL, please let us know.
Resolution:
Three possibilities:
1. [From Mike Rogers, University of Tennessee at Knoxville, on Global Aleph Users list:]
If you have the Z00R table, the following SQL can be used to locate such cases:
SELECT /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */
Z00R_DOC_NUMBER
FROM xxx01.Z00R
WHERE SUBSTR(Z00R_FIELD_CODE,1,3) = '090'
GROUP BY Z00R_DOC_NUMBER
HAVING COUNT(*) > 1;
You'll need to change the institution code (xxx01) to your own code.
2. [From Tania Gutman:]
Use fix_doc_do_file_08 in tab_expand RET:
RET fix_doc_do_file_08 more_090
Then create a new file in your bib xxx01/tab/import directory, called "more_090" (**this can be any name you set in col.3 of tab_expand); the new file should contain:
1 090## FIRST DELETE-FIELD
This will virtually delete the first 090 during p-ret-01 retrieval, leaving only records with more than one 090.
In p-ret-01, set Tag in record to "090##".
3. [From site:]
We discovered the Z00R table was never populated. And, with very minimal experience tweaking Aleph tables and Unix commands, not much progress via those avenues either.
We did eventually find a work around with good old Excel. Conditional formatting found and highlighted the duplicate doc nos. in a snap.
- Article last edited: 10/8/2013