SQL bulk add general note entry
Submitted by mac-mark on Tue, 2009-06-16 17:34.
Hi, I'm quite new to SQL, I've seen some similar posts but I wanted to check the best way to do the following. I need to bulk add a general note (500 entry) for a specific author (there are about 250 records). I'd be grateful if someone could give me some pointers on how to do this.
SQL bulk add general note entry
I'm not a cataloguer but it sounds like a MARC record update.
The MARC21 data is held in a blob type attribute and the content of the blob data cannot be updated in part via SQL.
Talis Alto extracts the blob and extracts the information so it can be edited and then updated. Potentially there are other approaches but these still are not bulk updates and could require additional tools or configuration. It is probably going to be quicker to update each work via Alto manually especially if this is a one-off job.
Brian Crampton
Developer, Talis