topic Re: How to access Oracle database via Cobol in Operating System - HP-UX

How to access Oracle database via Cobol

Andre Machado_1 — Fri, 27 Apr 2001 19:05:52 GMT

Hi body,

I need access a Oracle Database from a Cobol program, but I don?t kown.

I?d like a little sample.

Thank you!

Re: How to access Oracle database via Cobol

Thierry Poels_1 — Fri, 27 Apr 2001 19:11:58 GMT

Hi Andre,
Pro*Cobol is the thing you need. This will allow to incorporate SQL-statements in your Cobol programs. (Requires an Oracle license however)
sorry no (Pro*)Cobol examples from me
good luck,
Thierry.

Re: How to access Oracle database via Cobol

A. Clay Stephenson — Fri, 27 Apr 2001 20:18:01 GMT

AS Thierry says, Pro*COBOL is what you need. I've attached a sample of code that will give you an idea of what is involved. I'm not really a COBOL guy myself (C, C++) but I have done some work on replacing all the existing I/O with SQL and it works well. You can still retain conventional I/O as well. When you purchase PRO*COBOL you also get PRO/C.

Re: How to access Oracle database via Cobol

Tim Medford — Fri, 27 Apr 2001 22:10:39 GMT

Hi Andre.

Can you be more specific about what you're trying to do. What OS is Oracle running on? Where are the Cobol programs running? On the same platform?

If you have Oracle running on HPUX, and some old mainframe COBOL programs running on an IBM mainframe, you're going to need a lot more than Pro*COBOL to access Oracle. You will need and Oracle gateway product (Procedural or transparent gateway for example). This is a major architectural change I'm talking about.

We have some Legacy COBOL code that needs to access Oracle too. As much as I hate data replication, we opted to write an interface which loads the Oracle data into a DB2 database on the mainframe. The COBOL programs then access the data in DB2 on their native platform.

Regards,
Tim

Re: How to access Oracle database via Cobol

Andre Machado_1 — Sun, 29 Apr 2001 16:23:41 GMT

Hi Tim,

I have a L1000 Machine and MicroFocus Cobol 13.35 on HP-UX 11.00, and oracle 8 on some machine. I haven?t ODBC.

I need access a Oracle databse to verify the client table.

Thank you for your help!

Re: How to access Oracle database via Cobol

A. Clay Stephenson — Sun, 29 Apr 2001 17:43:18 GMT

Given that Pro*COBOL will work just fine on either a local machine or a remote database instance. If you are trying to connect to a remote oracle instance you don't need ODBC but you do need to oracle client software installed on the local machine and a listener configured on the remote machine. I would start out do very simple tasks and build on them. This is not difficult. I started out barely being to spell COBOL but nevertheless could connect and do oracle I/O very quickly. I was comfortable using SQL and doing the same task in C before I did any COBOL.

Re: How to access Oracle database via Cobol

Andre Machado_1 — Mon, 30 Apr 2001 19:22:11 GMT

I will access oracle from local host.

What I need?

Re: How to access Oracle database via Cobol

Joseph C. Denman — Mon, 30 Apr 2001 19:34:13 GMT

1. telnet to the machine with the oracle account
2. export ORACLE_SID=yoursid
3. sqlplus user/passwd
4. select whatever from table
5. exit

Hope this helps

...jcd...

Re: How to access Oracle database via Cobol

A. Clay Stephenson — Mon, 30 Apr 2001 20:13:50 GMT

If you are running on the local host. Sqlplus should already be installed. I can think of two ways to do this. 1) Install Pro*COBOL and examine the attached sample I've already sent or 2) if the SQL commands are simple you can build SQL statements within COBOL and write the to a text file 'on the fly' and then EXECUTE an external program (sqlplus) to read and process the SQL statements. Method 2 works but you will have to do a lot of text processing of the results withinn your COBOL program.
I would get the Pro*COBOL compiler; it is much easier and is a marketable skill.

Re: How to access Oracle database via Cobol

Andre Machado_1 — Wed, 02 May 2001 10:07:07 GMT

Where I get PRO Cobol?

Re: How to access Oracle database via Cobol

Thierry Poels_1 — Wed, 02 May 2001 10:10:06 GMT

Hi,
from Oracle company itself.
You'll need a license to run it. Maybe you can get a trail copy if you're still in development phase.
good luck,
Thierry.

Re: How to access Oracle database via Cobol

Jon McDermott — Fri, 04 May 2001 11:13:51 GMT

Oracle Pro*COBOL as a part of the Client installation process with Oracle 8.1.7. As stated previously, you'll need a separate license for Oracle Programmer - this allows you to use Pro*COBOL among other development tools.

There are two flavors of Pro*COBOL - Pro*COBOL 8.1.7 and Pro*COBOL 1.8.52. I've used Pro*COBOL 8.1.7 with HP COBOL B.13.35 quite a bit with good results. From what I understand, the 8.1.7 version is the "newer" version of the precompiler, and it seems to get any new features.

There are several sample programs that are installed with Pro*COBOL.

Note that the Oracle Installation Guide has some speicifc pre-Installation requirements for Pro*COBOL.