• Article Type: General
• Product: Aleph
• Product Version: 20

Desired Outcome Goal:
Report of Course Reserve items, grouped by course -- where the Reserve items have an item status of "03".

Procedure:
> s+ xxx50
SQL> set echo off
set pause off
set term off
set show off
set verify off
set heading off
set feed off

spool course_items.lst

select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ substr (z11_rec_key,6,80), z30_rec_key, z30_barcode from z30, z103, xxx30.z11 where z30_item_status = '03' and substr (z30_rec_key,1,9) = substr (z103_rec_key_1,6,9) and z103_rec_key like 'XXX30%' and substr (z103_rec_key,6,9) = z11_doc_number and z11_rec_key like 'CNO-S%'
group by substr (z11_rec_key,6,80), z30_rec_key, z30_barcode order by substr (z11_rec_key,6,80), z30_rec_key, z30_barcode;

spool off;