| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: No DBAs needed on AS400
DataTrieve!! That useful pile of *&^%!! I have not heard of that tool in the
last 10 years, boy are you ever tweaking the memory! It was one tool that I
hated to love. Yes you did have to do some configuration before it would work,
but once it was working could you ever parse a file. Slice & Dice through mega
byte logs with ease! So long as no one was trying to also update the file, then
you'd have problems. Damn, those were the days!! :-)
Dick Goulet
____________________Reply Separator____________________ Author: "Jay Hostetter" <jhostetter_at_decommunications.com> Date: 4/11/2002 10:50 AM
Thank you for all the replies that I have received.
It sounds like a version of DB2 comes along with the OS, or a full fledged
version of DB2 can be installed. From what I have heard about their AS400
system, they can access their files directly - without going through a database.
This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured
to use files, which would mean that you could either update the file directly or
go through DB2 - is this correct? I can also make another VMS relation here -
we had a tool called DataTrieve which you could configure to use regular files.
You could then issue SQL like statements through DataTrieve against your files.
Is DB2 like this? Somebody needed to configure DataTrieve before it could
reference a file - what about DB2? Unless "they" never changed/added files on
the AS400.
Comments were made that DB2 and AS400s are not "open". Does this mean that you
couldn't write a client/server program to access data on DB2 (say using C++ from
Windows 2000)?
I'm off to find on-line docs...
Answers to some questions:
>Does it have DB2 as the database?
He didn't say that it was running DB2.
>If you are performing queries from Oracle to DB2 (SQL Queries), that is being
performed through Oracle's gateway product.
We are not doing this.
>>> DWILLIAMS_at_LIFETOUCH.COM 04/11/02 10:44AM >>>
Jay - I can see the manager's confusion. After all, one expects computers to
become easier and require less effort to maintain as time goes by. I
forwarded your question to another list that has some AS/400 programmers.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: jhostetter_at_decommunications.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Apr 11 2002 - 14:33:31 CDT
 |
 |