List of serials subscriptions, with ISSN numbers
- Article Type: General
- Product: Aleph
- Product Version: 20
Desired Outcome Goal:
Produce a list of current subscription titles with ISSN numbers.
Procedure:
1. Run the following SQL to create a file of ADM #'s of current subscription (z16) records:
s+ xxx50
set echo off
set heading off
set linesize 9
set pagesize 20000
spool current_z16
select distinct substr (Z16_REC_KEY,1,9) from z16 where Z16_COPY_TO_DATE > 'yyyymmdd' order by substr (Z16_REC_KEY,1,9);
2. Use the method described in KB 8192-1591 ("Appending library to each line in file of record numbers") to append "XXX50" to each number: :1,$ s/$/XXX50/ .
3. Delete the five or six non-number lines at the beginning and end of the file.
4. Use the file from step 3 as input to Service manage-70 (Retrieve Record Keys), specifying the "ADM-to-BIB" option
5. Run print-03 ("Download machine-readable records") in xxx01, using the manage-70 output file as input, specifying 245 and 022 as the fields.
Additional Information
* serial-06 (Serials - Print Arrived Issues Report), lists every arrived issue of newspaper, etc. Not workable.
* Export of the titles and ISSNs to an Excel file is desired .
Category: Serials (500)
Subject: Subscriptions (500)
- Article last edited: 10/8/2013