Very Computer

by **Shaochun L** » Tue, 08 Apr 1997 04:00:00

Does anyone outthere know how to connect Oracle with Micro Focus COBOL,
I am urgently in converting some Mirco Focus COBOL files to Oracle TABLE.
Any suggestion would be appreciated. Thnak,Shaochun,

by **L120** » Tue, 08 Apr 1997 04:00:00

Are you saying that you wish to access ORACLE tables from within a Micro
Focus Cobol program ? If so, then you need to use the PRO*Cobol compiler,
check out the precompiler manuals for more details.
If you just wish to load files created by a Micro Focus Cobol program into
an ORACLE table, then, as long as you do not need to update existing rows,
SQL*Loader is worth looking at - it's detailed in the Utilities manual.
If you are updating existing rows, then you'll have to use PRO*C,
PRO*Cobol or PL./SQL (ORACLE v7.3 and above).
If you have any queries mail me
Rob
--------------------------------------------------------------------------
--------------------------------------------
Subject: How to connect with Micro Focus COBOL

Date: 7 Apr 1997 17:07:46 GMT

Does anyone outthere know how to connect Oracle with Micro Focus COBOL,
I am urgently in converting some Mirco Focus COBOL files to Oracle TABLE.
Any suggestion would be appreciated. Thnak,Shaochun,

by **Matt Shahnava** » Wed, 09 Apr 1997 04:00:00

Quote:> Does anyone outthere know how to connect Oracle with Micro Focus COBOL,
> I am urgently in converting some Mirco Focus COBOL files to Oracle TABLE.
> Any suggestion would be appreciated. Thnak,Shaochun,

First you need to install PRO*COBOL, Oracle's COBOL precompiler.

Then use embedded SQL to connect to the database:

EXEC SQL
CONNECT :USERNAME IDENTIFIED BY :PASSWD
END-EXEC.

Good Luck with the conversion,

Matt

by **info..** » Tue, 15 Apr 1997 04:00:00

> Does anyone outthere know how to connect Oracle with Micro Focus COBOL,
> I am urgently in converting some Mirco Focus COBOL files to Oracle TABLE.
> Any suggestion would be appreciated. Thnak,Shaochun,

Oracle have Pro*Cobol product available.

However, we find it little bit buggy and have some unfavourable
behaviour.
Generally, don't expect it to be as easy and staight forward as Pro*C.

But, it is still a solution.

by **Brian M. Bigg** » Wed, 16 Apr 1997 04:00:00

Quote:> > Does anyone outthere know how to connect Oracle with Micro Focus COBOL,
> > I am urgently in converting some Mirco Focus COBOL files to Oracle
TABLE.
> > Any suggestion would be appreciated. Thnak,Shaochun,

> Oracle have Pro*Cobol product available.

> However, we find it little bit buggy and have some unfavourable
> behaviour.
> Generally, don't expect it to be as easy and staight forward as Pro*C.

Um, Pro*COBOL is about as easy as it gets. It's not too tough to use,
really. Just define some variables and execute some EXEC SQL statements.
Just like any other Oracle precompiler language.

We have had some problems with Micro Focus COBOL on the HP, DEC and AIX
platforms, but nothing really out of the ordinary. We haven't really run
into any major bugs, either. Pro*COBOL is still a very viable solution,
especially if you have legacy programs you need to convert to Oracle or to
the UNIX environment. If you're starting from scratch, C/C++ is probably a
better choice.

Regards,
Brian

--
Brian M. Biggs http://www.cincom.com/
Lead Software Engineer voice: (513)677-7661
Cincom Systems, Inc.

* To reply to me via e-mail, just remove the leading underscore from
my return address. I had to do this to cut down on the number of
spammers pulling my address from UseNet postings and sending me
junk e-mail.