Extracting bib + holdings for bib records with a certain HOL record field/subfield

Description

We need to extract (in MARC format) all of the bib records which have an 852 $$u field/subfield in a connected HOL record. We also need the holdings data extracted with these bib records.

Resolution

There are three steps to this process:

1) Create a list of xxx60 record numbers (in the form "000123456XXX01") for records which contain an 852 $$u field.  Assuming that the xxx60 852 $$u isn't indexed, the ret-01 Service would be run in the xxx01 bib library, with, as described in the article " p_ret_01: including 852 field from Holdings record ", the following line added to your xxx01 tab_expand:

RET        expand_doc_bib_hol_usm 

ret-01 would then be run specifying "852##" as the "Tag + Indicator" and "u" as the Subfield.  [Note:  this  is for the case where only records with an 852 $$u field are wanted in the output file, but any other field/subfield combination could be specified.] 

2) Add the following lines to the xxx01 tab_expand:

PRNT-03    expand_doc_bib_hol_usm
PRNT-03    expand_doc_bib_z30

expand_doc_bib_hol_usm will include all the HOL record fields in the output and  expand_doc_bib_z30 will include all of the fields specified in the ./xxx01/tab/expand_doc_bib_z30 table.

3) Run the print-03 Service specifying:

 * the output from step 1 as the input file
 * "ALL" in Field 1
 * "M1" as the file format (MARC format, with just the numeric tags) or "M2" to also include alphabetic tags
 * "PRNT-03" as the expand routine
 * UTF_TO_MARC8 as the Character Conversion routine 

• Article last edited: 1-Nov-2017