Voyager to Alma Migration Query: Identify Bib Records with an OCLC number in the 035 subfield 9 but no 035 subfield a

When migrating from Voyager to Alma, you may want to identify and review those BIB records that have an OCLC number in 035 subfield 9 but have no 035 subfield a.

 OCLC numbers are the foundation of bibliographic matching and de-duplication.  Bibliographic records should ideally have a single, unique source identifier.

These queries, which you can run using Voyager Prepackaged Access Reports, find BIB records that lack a control number in 035 subfield a, but that also have an OCLC control number in 035 subfield 9.

Additional information: In migrations between integrated library systems, record control number data may have been migrated from either the 001 or the 035$a into an 035$9 field. Staff can review records that have an OCLC number in the 035$9, and that have no other control number. Determine if the OCLC number in 035$9 is still valid in OCLC by searching WorldCat. If the number is valid, you can change the subfield value from $9 to $a. If the OCLC number is no longer valid, then change the subfield value from $9 to $z.

The main query may contain several lines of 035 data in a long text field, if the record includes multiple 035s. Adjust the row height of the results in Access or in Excel to see all 035 data.

Subquery: Save this subquery with the name "Bibs_with_no_035a_subq", but don't run it.

SELECT BIB_MASTER.BIB_ID
FROM BIB_MASTER
WHERE (((BIB_MASTER.BIB_ID) Not In (SELECT BIB_INDEX.[BIB_ID]
FROM BIB_INDEX
WHERE (((BIB_INDEX.INDEX_CODE)="0350")))));

Main Query (run this query):

SELECT BIB_INDEX.BIB_ID, BIB_INDEX.INDEX_CODE, BIB_INDEX.NORMAL_HEADING,
getfieldrawall(getbibblob([BIB_INDEX].[bib_id]),'035') AS bib035
FROM BIB_INDEX INNER JOIN Bibs_with_no_035a_subq
ON BIB_INDEX.BIB_ID = Bibs_with_no_035a_subq.BIB_ID
WHERE (((BIB_INDEX.INDEX_CODE)="0359")
AND ((BIB_INDEX.NORMAL_HEADING) Like "*OCOLC*"));

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.