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.