Re: Company thought DB2 will be better than Oracle.

Posted in 2003

Darin McBride — Sun, 14 Sep 2003 03:25:02 GMT — source: Usenet: comp.databases.informix

Daniel Morgan wrote: > Mark A wrote: > > Sorry to say this but the code base for Oracle is 100% identical between > platforms. I can develop on Win98, export tables, data, code, etc. > Import directly to any other platform-operating system that Oracle > supports and it runs, perfectly, with zero modifications. I think you're confusing _Oracle_ code being identical, and the _interface_ being identical. I highly suspect that both Oracle and DB2 for LUW have pretty much the same proportion of "identical" code between all supported platforms vs "platform-specific" code, and that their APIs would stay 100% the same across all supported platforms. > The only difference I can possibly think of would be things that are > path specific such as c:\\temp changing to /opt/. > > It isn't about insulting your intelligence ... it is a fact. I think it's more like a misunderstanding.

↪ replying to Darin McBride

Daniel Morgan — Sat, 13 Sep 2003 20:57:51 -0700 — source: Usenet: comp.databases.informix

Darin McBride wrote: >Daniel Morgan wrote: > > >>Mark A wrote: >> >>Sorry to say this but the code base for Oracle is 100% identical between >>platforms. I can develop on Win98, export tables, data, code, etc. >>Import directly to any other platform-operating system that Oracle >>supports and it runs, perfectly, with zero modifications. >> >> > >I think you're confusing _Oracle_ code being identical, and the >_interface_ being identical. > Not at all. After as many years as I have with both products that proposition has a zero probability. > I highly suspect that both Oracle and DB2 >for LUW have pretty much the same proportion of "identical" code >between all supported platforms vs "platform-specific" code, and that >their APIs would stay 100% the same across all supported platforms. > I suspect, no I know, you are incorrect. >>The only difference I can possibly think of would be things that are >>path specific such as c:\\temp changing to /opt/. >> >>It isn't about insulting your intelligence ... it is a fact. >> >> > >I think it's more like a misunderstanding. > > Not a misunderstanding at all. One product uses PREVVAL the other CURRVAL. They are different. This just happens to be one of the differences. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

↪ replying to Darin McBride

Peter — 14 Sep 2003 04:24:26 -0700 — source: Usenet: comp.databases.informix

I have worked on both Oracle and DB2 from Main frames to UNIX and to NT. DB2 on Main frames is not same as on UNIX, LINUX or NT. I have never seen disappearance of DB2 instance on OS/390. I have never seen DB2 DBA being asked to watch swap space on Main frames for binding. I can not give you here the name of famous financial company in New York moving there critical DB2 applications from AIX to Main frames. It sounds strange but if you support DB2 on production servers in the same company for 2 years, you will understand my point that company is taking business risk by using DB2 on non-Main frames system. It is possible the situation may change in 5-10 years. Peter Darin McBride <dmcbride@naboo.to.org.no.spam.for.me> wrote in message news:<icR8b.955682$3C2.21607107@news3.calgary.shaw.ca>... > Daniel Morgan wrote: > > > Mark A wrote: > > > > Sorry to say this but the code base for Oracle is 100% identical between > > platforms. I can develop on Win98, export tables, data, code, etc. > > Import directly to any other platform-operating system that Oracle > > supports and it runs, perfectly, with zero modifications. > > I think you're confusing _Oracle_ code being identical, and the > _interface_ being identical. I highly suspect that both Oracle and DB2 > for LUW have pretty much the same proportion of "identical" code > between all supported platforms vs "platform-specific" code, and that > their APIs would stay 100% the same across all supported platforms. > > > The only difference I can possibly think of would be things that are > > path specific such as c:\\temp changing to /opt/. > > > > It isn't about insulting your intelligence ... it is a fact. > > I think it's more like a misunderstanding.