RE: SQL queries of MARC data

[zoltan dot tomory at mobot dot org]

Meg,

I'm not a guru & I'm not on Oracle. On my last system I did use SQL. 

What problems do you have specifically (e.g.)?
Do you know what table(s) the MARC data lives in? 
The names of the columns?
Can you access the contents of a single field?
Is the problem doing joins?

Show us what you've got & let's brainstorm.


Zoltan Tomory




-----Original Message-----
From: Meg Westbury [mailto:mwestbury at kcls dot org]
Sent: Thursday, January 20, 2005 12:38 PM
To: INNOPAC at innopacusers dot org
Subject: SQL queries of MARC data


Hello.  We are a brand new Millennium site.  We are running Millennium on an
Oracle database and would like write SQL statements that pull data from the
MARC records.  It seems like this should be easy to do, but we haven't been
able to figure it out and the folks at Innovative, for whatever reason, have
not been forthcoming with the information.  Maybe it's not possible, but I
thought I would poll the gurus, as it seems like it should be one of the
simplest queries possible.  
 
Thanks very much in advance, 
 
Meg Westbury
King County Library System
mwestbury at kcls dot org

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---