- Article Type: General
- Product: Aleph
- Product Version: 16.02
p_ret_01 takes too long at our site. Is there some way we can get the keys of records updated since June 14, 2008, for library abc01?
If you don't want to run p_ret_01, you could run the following SQL:
set echo off
set pause off
set term off
set show off
set feed off
set verify off
set heading off
select z13_rec_key from z13 where z13_update_date > '20080613';
and then append "ABC01" to the end of each line as described in KB 8192-1591.
- Article last edited: 10/8/2013