Re: From Cobol+Db2 To Oracle

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 14 Jul 2009 12:14:46 -0700 (PDT)
Message-ID: <eb8657c7-be01-4fba-b005-b24cd839e776_at_t13g2000yqt.googlegroups.com>

On Jul 14, 11:27 am, Revenge <amast..._at_gmail.com> wrote:
> Hi all,
>
> I have some Cobol procedures that use DB2 as database.
>
> I need to convert/export/migrate/embed these procedures into Oracle
> (database and procedures)
>
> Reading on internet (forums and newsgroups) I think that it could be
> done using Pro*Cobol + Net Express
>
> Could anoyone tell me how it works? (i didn't find any detailed
> information)
> I tried to run procob.exe on a cobol source file and it creates 2
> files (.lis and .cbl)
> There's a file "makeit.bat" that runs procob... and then cobol.exe and
> cbllink.exe that I think are in Net Express
>
> Could anoyone explain me how does it works and if is it possible to
> use cobol code into pl/sql procedures?
>
> Thanks in advance,
>   Revenge

There's like a 1200 page free oracle documentation on the cobol precompiler.   I would take a look at that ...

There are sample cobol programs that come in one of the admin or sample directories when you install the correct stuff from the oracle side.

What cobol are you planning on using ( Microfocus sounds like to me )? Lots of information on the Oracle/Microfocus combination available from the cobol vendor.

The stored procedures in db2 are not going to translate directly into oracle ... they will need some attention and lots and lots of testing.

I would seriously look at bringing in some consulting resources who have done projects like this! Received on Tue Jul 14 2009 - 14:14:46 CDT