• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Description:
The sql from KB 8192-2744 (see below) produces about 300 doc record numbers. It would be helpful to add titles so that music librarian could look up likely titles and other staff could work on their documents. Is there a way to add titles, even if just z13 titles?

SQL> select z00_doc_number from z00 minus select substr (Z103_REC_KEY_1,6,9) from z103 minus select
z13_rec_key from z13 where Z13_TITLE is null;

Resolution:
This SQL will give you the title and the rec-key:

> s+ abc01
SQL> select z13_title, z13_rec_key from z13 where z13_rec_key in (select z00_doc_number from z00 minus select substr (Z103_REC_KEY_1,6,9) from z103 minus select z13_rec_key from z13 where Z13_TITLE is null);

• Article last edited: 12-Mar-2016