Description

What SQL will show bib/ADM keys which are out of synch?

Resolution

This SQL gives a count of cases where the Bib number does not match the ADM number:

> s+ xxx50
cjh50@ALEPH22> select count(*) from z103 where substr (z103_rec_key_1,1,5) = 'XXX01' and  substr (z103_rec_key,6,9) ^= substr (z103_rec_key_1,6,9) order by substr (z103_rec_key,1,14);

 
The following SQL can be used to list these cases:

> s+ xxx50
SQL> select substr (z103_rec_key,1,14), z103_rec_key_1 from z103 where substr (z103_rec_key_1,1,5) = 'XXX01' and  substr (z103_rec_key,6,9) ^= substr (z103_rec_key_1,6,9) order by substr (z103_rec_key,1,14);

• Article last edited: 27-Mar-2016