Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p_ret_01 takes too long; SQL to get keys of records updated since yyyymmdd

    • 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

    spool xxxxxx;

    select z13_rec_key from z13 where z13_update_date > '20080613';

    spool off;

    and then append "ABC01" to the end of each line as described in KB 8192-1591.

    • Article last edited: 10/8/2013