[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: arsclist Cataloging Software
I should clarify here! What I meant was that mainframe systems use (to
a great extent) mainframe-specific programs like Oracle and DB2. There
is a pc version of Oracle (love to find an old version cheap, just to look
at it) though I'm not sure of how compatible it is with the "full-size"
mainframe
Oracle; I also know that MS can provide ODBC drivers for most mainframe
programs so I could write VB (and Visual C++, I think) programs which could
access mainframe data. I had no idea, though, that dBASE (or even xBASE
format) was used to any extent on mainframe computers.
Obviously, SQL can be used to connect any data where the app running the
SQL can "understand" the format in which the table(s) in question was
created.
If I tell my app to "SELECT Title FROM Tracks WHERE..." and it can find
the Tracks table (or file, in xBASE) and find a Title field in that, it can
go from
there. However, our good ol' average user will start up his trusty MS Access
(or whatever he is using for cataloguing, including WordPerfect tables) and
probably panic when he encounters an Oracle or DB2 archive of data he could
use...
...stevenc
----- Original Message -----
From: "Dave Bradley" <db65@xxxxxxx>
To: <ARSCLIST@xxxxxxxxxxxxxxxx>
Sent: Monday, December 16, 2002 9:16 PM
Subject: Re: arsclist Cataloging Software
> At 04:51 PM 12/16/2002 -0500, you wrote:
> >Also, for folks at really big institutions still using mainframe
> >systems...most database apps on these are unknown in the
> >personal computer world (and the two don't "speak," either!)
>
> As someone who did mainframe programming for years, I'm surprised you've
> not seen the mainframe world's most popular database apps on other
> platforms. They are DB2 and dbase. DB2 is readable via SQL selects, and
> mainframe systems can quite easily talk with other systems. In fact, I've
> worked with Oracle systems on a UNIX box that directly imported records
> from an MVS system running a DB2 database.
-
For subscription instructions, see the ARSC home page
http://www.arsc-audio.org/arsclist.html
Copyright of individual posting is owned by the author of the posting and
permission to re-transmit or publish a post must be secured
from the author of the post.