[OPEN-ILS-DEV] how to batch edit a marc tag in EG using sql?

[Melissa Belvadi]

I have a set of 135 records which need our proxy string prepended to
their 856u. I am comfortable with sql generally and the sql table
structure of Evergreen in particular (eg can precisely identify via
query exactly the bib records in biblio.record_entry and in
metabib.real_full_rec) need updating, and I can formulate a precise
pattern to the modification needed, but I'm not familiar with how the
indexing/display triggers etc. inter-relate in Evergreen to know which
table entries need to be changed to make sure everything is updated
correctly. The 856u isn't included in any search indexing in our system,
just display.
 
Does anyone have any sample code for this kind of thing?
 
Thanks!
 
Melissa
 
 
 
 

---
Melissa Belvadi
Emerging Technologies & Metadata Librarian
University of Prince Edward Island
mbelvadi at upei.ca
902-566-0581
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091029/ee20733a/attachment.htm