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

Description:
We have a record (491090) that was converted with 25,000 other records as well as holdings, subscription and item records (correctly according to specs - bad data in the "number of copies" field.)

So, I'm trying to get rid of the extra data while leaving the correct info.
I've been able to identify, by system number, and delete via SQL, the extra holdings, subscription and item records.
I then forced an update of the BIB record via the Util menu.

I think I still need to clean up the various z103 files. I'm not yet certain that I understand the z103 tables yet - are there separate ones in abc01, abc50 and abc60 that all need to get cleaned up? Are there any other files that may need to get cleaned up? Any tips welcomed!

Resolution:
This SQL shows you what z103s exist (in the ABC01 library):

SQL-ABC01> select Z103_REC_KEY, Z103_REC_KEY_1 from z103 where Z103_REC_KEY_1 like 'ABC01000491090%';

Though there is only 1 ABC50 z103, there are thousands of DUK60.

You need to run these SQLs to delete them:
SQL-ABC01> delete from z103 where Z103_REC_KEY_1 like 'ABC01000491090%';

SQL-ABC50> delete from z103 where Z103_REC_KEY_1 like 'ABC01000491090%';

SQL-ABC60> delete from z103 where Z103_REC_KEY_1 like 'ABC01000491090%';

You should back up the z103 before doing this.