Re: Oracle & DB2 source code

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 06 Sep 2007 19:31:20 +0200
Message-ID: <5karreF2sqr8U1@mid.individual.net>

On 06.09.2007 15:53, mvsguy wrote:

>> Also DB2 supports multiple interfaces such as ODBC and Exec SQL.  The
>> base code could be COBOL but the calls to the database could use a
>> different interface than your assumptions.

>
> Thank you for your prompt reply.
>
> My knowledge of either RDBMS is limited; I'll admit this. Your
> comment above implies Oracle doesn't support ODBC or EXEC SQL. Could
> you clarify?

No, Mark rather meant - if I am reading him properly - that when talking to DB2 from Cobol you might be using a special interface that is not supported by Oracle (like OCI is not supported by DB2). Oracle does support ODBC for sure.

Things I would look at (besides the aforementioned data types and error handling): transactional behavior, triggers, constraints and locking.

Kind regards

robert Received on Thu Sep 06 2007 - 12:31:20 CDT