Skip to main content
Ex Libris Knowledge Center

Including OCLC# on SQL report


  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



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.


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
  • Was this article helpful?