Re: Oracle & DB2 source code

On Sep 6, 8:22 am, mvsguy <kkin..._at_fuse.net> wrote:
> I have a question regarding a common source code base supporting both
> Oracle & DB2.
>
> I'm in a tough spot. I know people who assume the same COBOL source
> code can used regardless whether someone is using DB2 or Oracle. (This
> is for a product running on Win. Unix and z/OS.)
> I'm highly skeptical of this but don't have any proof to support my
> position.
>
> Can someone out there help by giving some real life examples?
>
> Regards,
> MVSGuy

I have never compared the two databases on this subject, but try looking in the Pro*COBOL manual for Oracle and compare this to the equilivent DB2 manual. Even though the EXEC SQL may be identical I would expect that some programming changes would be required due to data type mapping and error handling.

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.

HTH -- Mark D Powell -- Received on Thu Sep 06 2007 - 08:40:58 CDT