Re: SQL queries of MARC data

[Adam Brin <abrin at brynmawr dot edu>]

While looking for other things, I did see this in the Manual... not sure 
if it's too helpful:

http://csdirect.iii.com/manual_silver/rmil_oracle_records_intro.html

If you go back/forward a bit you can see E/R diagrams and some table 
descriptions.

adam brin
Tri-Colleges Systems Librarian

Jeff Campbell wrote:
> I'm interested to see the success of other institutions too.  This is one of
> the things I'd like to accomplish after we finish implementation.  One of
> the challenges to this will be the data structure III using in the Oracle
> implementation....there is a lot of BLOB data in them there fields.  One
> thing you should ask for from III is the data structure of your Oracle
> backend.  Happy querying! 
>
> -----Original Message-----
> From: innopac-bounces at innopacusers dot org
> [mailto:innopac-bounces at innopacusers dot org] On Behalf Of Meg Westbury
> Sent: Thursday, January 20, 2005 1: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
>
> --
> 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