Skip to main content
ExLibris

Knowledge Assistant

BETA
 
Aleph

 

Ex Libris Knowledge Center
  1. Search site
    Go back to previous article
    1. Sign in
      • Sign in
      • Forgot password
  1. Home
  2. Aleph
  3. Knowledge Articles
  4. SQL query to extract datasets of locally-created authority records

SQL query to extract datasets of locally-created authority records

  1. Last updated
  2. Save as PDF
  3. Share
    1. Share
    2. Tweet
    3. Share
No headers

 

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

 

Question    
How to generate an SQL query to extract datasets for locally-created and locally-modified records from the xxx10 (Authorities). 

What entities and attributes could be used to make a relationship and get the required result sets?

 

Answer    
Aleph doc (Z00) records, such as, the bib records or the authority records, cannot be queried directly by SQL because their variable-length fields (everything from the 010 field-up) is stored in Binary Long OBject format, which is not searchable by SQL. (Note: If you have the z00r table built in the alb10 library, you *could* query that table via SQL.) 

This is the best way to do this: 

1. If the xxx10 MARC tag being queried is indexed, then either 

a. search it in the GUI (the binoculars) and then click on "Save" to save it to the server; or 
b. run the GUI ret-03 Service to retrieve the record numbers of records which satisfy the query 

2. If the MARC tag being queried is not indexed, then run the xxx10 GUI ret-01 Service. 

In either case the result set will be a file with lines looking like this: 

000123456XXX10 
000234567XXX10 
<etc.> 

3. Take the file from step 1 or 2 and use it as input to the xxx10 print-03 Service. Either the entire record or a desired set of tags from the record can be specified in this service's "Field"s parameters.

 

 


  • Article last edited: 02-Mar-2016
View article in the Exlibris Knowledge Center
  1. Back to top
    • SQL Query produces a non-ending Oracle Process
    • SQL report of bib records linked to multiple collection codes or call numbers
  • Was this article helpful?

Recommended articles

  1. Language
    English
    Product
    Aleph
  2. Tags
    This page has no tags.
  1. © Copyright 2025 Ex Libris Knowledge Center
  2. Powered by CXone Expert ®
  • Term of Use
  • Privacy Policy
  • Contact Us
2025 Ex Libris. All rights reserved