Retrieving records based on fixed field values

• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
We need a list of records with:

LDR byte 7=m AND
008 byte 24 not equal to t AND
008 byte 24 not equal to j.

Is this possible?

Resolution:
Three ways this could be done are shown below:

1. Use the Z00R table. {The Z00R has a separate record for each field in each record and fixed fields are searchable using such SQL as:

SQL> select z00r_doc_number from z00r where Z00R field code like 'LDR%' and substr (z00r_text,8,1) = 'm' ; }

I find, however, that you have "CREATE-Z00R=N" specified in the bib tab100 table and no Z00R has been built.

So, choice #1 is to change this to "CREATE-Z00R=Y" and run p_manage_07 -- specifying "Update only Z00R" as the Record Type. This choice is the best if only staff need to access this field and if you think there might be other such cases.

Note: Since MARC calls the first byte 0 rather than 1, you need to add 1 to any MARC fixed-field byte to get the actual position. Thus, in the preceding case, for MARC LDR byte 7, we look at ALEPH LDR byte 8.


2. Add each of the two positions you want to index to tab22 like this:

USER-DEF-3 1 LDR## 0008
USER-DEF-4 1 008## 0025

and run p_manage_07, specifying "Update only Z13" as the Record Type. The Z13_user_def_3 and _4 could then be searched using SQL. This might be the best choice if only staff need to access the field and if you think that these are the only such cases there will be. (Unlike choice #1, any similar addition requires a re-run of p_manage_07.)

3. If you want patrons to be able to search the field, then create a new index for it in tab00.eng and send the field to that index using tab11_xxxx. (See the document "How To Add a New Index" in the Documentation Center for details.)

See also KB 16384-8641.