How to create file of bib/doc records updated on a certain date

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