Version 1 (modified by Dan Scott, 14 years ago) (diff)

SQL for adding an MFHD record

Adding a MFHD record to a bibliographic record

Assuming that your cataloguers are willing to create brand new 853 and 863 fields, the following approach will generate a stub MFHD record for them:

  1. Start by finding the record ID for the bibliographic record
  2. Then issue the following SQL (substituting the record ID and owning library ID in the appropriate spots):
    INSERT INTO serial.record_entry (record, marc, last_xact_id, owning_lib) values (859846, '<record xsi:schemaLocation="" xmlns:xsi="" xmlns=""> <leader>00263cy  a22000974  4500</leader> <controlfield tag="001">40640</controlfield> <controlfield tag="005">20090714132854.0</controlfield> <controlfield tag="008">040712                eng 080109</controlfield> <datafield tag="852" ind1=" " ind2=" "> <subfield code="b">DESMARAIS</subfield> <subfield code="c">Periodicals</subfield> </datafield><datafield tag="866" ind1=" " ind2=" "><subfield code="a">PLACEHOLDER</subfield></datafield></record>', 'foo', 103);