How to get list of items with z30_temp_location='Y'

Description

We need to retrieve items that are coded with a temporary location (z30_temp_location='Y'). We want to cross it with other files so an aleph sequential file in xxx50 is what we need. How can we create such a list? 

Resolution

We couldn't think of any easy way to do this with Aleph services.  The SQL script shown below will do it.  

            <SQL script:>

set echo off
set pause off
set term off
set show off
set feed off
set verify off
set heading off
set pagesize 50000
set linesize 15

spool temp-location-list

select z30_rec_key from z30 where z30_temp_location = 'Y' order by z30_rec_key;

spool off
exit

          <end script>
 

If you want, you could add other information to the "select", such as:  

select z30_rec_key, z30_sub_library, z30_collection, z30_call_no from z30 where z30 where z30_temp_location = 'Y' order by z30_rec_key;

• Article last edited: 1-Sep-2017