• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
It seems we have patrons who lack a z308 type 01 (barcode). Can you give us SQL to locate such patrons?

Resolution:
The following SQL will do that:

> s+ xxxnn <where xxxnn is your $usr_library>

SQL> select z308_id from z308 where substr (z308_rec_key,1,2) = '00' minus select z308_id from z308 where substr (z308_rec_key,1,2) = '01';

• Article last edited: 10/8/2013