• 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