tab11_ind - 035 change makes OCLC number unsearchable
- Article Type: General
- Product: Aleph
- Product Version: 16.02
Description:
In PROD/reindexing we added the subfield "z" in the section for the 035
035## PNO az
035## 035 a
It was reported when searching oclc numbers, certain records are not pulling up correctly, I am thinking its because of the new setup:
system #6357703
|a (OCoLC)00724018 |z (OCoLC)29392609
Resolution:
Looking at the PNO with the following SQL:
SQL-ABC07> select z11_rec_key from z11 where z11_doc_number = '006357703';
We see this:
PNO 0072401829392609
The $$a and $$z have been combined into a single z11_rec_key.
It is your intention that both the $$a and $$z be browsable. You will need to do the same kind of thing with the 035 as you have the 010, that is, in tab11_ind, change:
035## PNO az
to:
a035 PNO
z035 PNO
and add these to tab_expand_extract:
035## a a035
035## z z035
Be sure to stop/restart ue_01 before testing.
- Article last edited: 10/8/2013