How to create STA $$aSuppressed for Withdrawn, Missing, etc., items

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

Article Type: General
Product: Aleph
Product Version: 20

Desired Outcome Goal:
Prevent creation of z00p / sending of record to Primo by adding STA $$aSuppressed field to bib record for ADM's with only items which are not supposed to display in OPAC.

Procedure:
1. Run the following SQL to produce a file of doc numbers of ADM records which have only items which are not supposed to display in OPAC:

> s+ xxx50

set echo off
set pause off
set term off
set show off
set verify off
set heading off
set feed off

spool suppstatus.lst

select substr (z30_rec_key,1,9) from z30 minus select substr (z30_rec_key,1,9) where z30_item_process_status not in ('WD','MI');

spool off;

(Modify the list of item processing status codes as desired.)

2. Append your "XXX50" ADM library code to suppstatus.lst lines, as described in KB 8192-1591 (Appending library to each line in file of record numbers).

3. Run manage-70 (Retrieve Record Keys) in xxx50, using file from step 2 as input, specifying Conversion Type "ADM-TO-BIB", to create a file of the bib record numbers for these ADM's.

4. Run manage-21 (Global Changes) in xxx01, with the file produced by step 3 as input, to add an "STA $$aSuppressed" field to each record.

Category: Publishing

Subject: Publishing Services

Article last edited: 10/8/2013