Including OCLC# on SQL report
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Question
How can the OCLC number be added to an SQL report? {A search of the Oracle tables for UPPER(COLUMN_NAME) LIKE '%OCLC%' gets 'no rows returned'.} The report is based on the xxx50.Z30 and the xxx01.Z13.
Answer
The OCLC number is in the bib record 035 field -- which, of course, is not searchable via SQL. By default, the OCLC# is not included anywhere else in the system.
Two possibilities:
1. If xxx01 z00r records (bib records in fixed-length format) are being built, then the OCLC# can be selected as follows:
SQL> select z00r_text from z00r where z00r_field_code like '035%';
2. If not, then the oclc# could be added to the ucd01 z13u table by including the following line in tab22:
USER-DEF-n 1 035##
and running the manage-07 Service to rebuild the z13 and z13u.
- Article last edited: 28-Feb-2016