How to create file of bib/doc records updated on a certain date
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
How can we create a file record numbers of records updated on a certain day / in a certain month for a routine (such as manage-40) expecting "ret-01"-format ("000123456USM01") input?
Resolution
The following script can be used to create a input file with records for a particular date range:
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 14
spool doc-record-numbers-for-particular-month
select select Z13_REC_KEY || 'XXX01' from z13 where Z13_UPDATE_DATE like '201610%' or Z13_OPEN_DATE like '201610%';
spool off
exit
The "|| ‘XXX01’" appends the library code to the end of each doc number.
- Article last edited: 1-Sep-2017