Re: Possibly stupid question for you IBM mainframers... :-)

From: Joachim Pense (spam-collector_at_pense-online.de)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 20:24:24 +0200

Howard Brazee wrote <ccuiuf$d6k$1@peabody.colorado.edu>:

> Switching from one relational database using SQL to
> another is
> trivial. The differences between ways of handling DB2 code within CoBOL
> programs can be bigger than switching between Oracle and DB2.

I would not buy that. While SQL is SQL is SQL, the details differ. That is
not really an issue; what is more important is that you can forget half of
what you know about writing performant Queries in DBMS 1 if you switch to
DBMS 2. Also, there are all kinds of locking and other kinds of behavior,
which are particularly different between Oracle and the rest of the world.
While it is trivial to write a trivial SQL statement in just any relational
DBMS, it is less trivial to avoid freezing down the whole system after you
switched.

Joachim

Relevant Pages