Home » Infrastructure » Other Operating Systems » Pro * Cobol
Pro * Cobol [message #615819] Mon, 09 June 2014 10:38 Go to next message
apru
Messages: 4
Registered: June 2014
Junior Member
Hi

I have a requirement to access Oracle database from z/os environment.Currently I am using DB2 database which is integrated with z/os.Now I have to access an external Oracle database from z/os.I read about an option called Pro*Cobol but did not get proper details regarding the product like if it is open source or not,what is the process for installation in z/os,JCLs required etc.I even doubt if it available for z/os.Can some one provide hints on the topic.Thanks in advance. Smile
Re: Pro * Cobol [message #615820 is a reply to message #615819] Mon, 09 June 2014 10:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
AFAIK, the Pro*???? are just pre-compilers which run on the DB Server.
Re: Pro * Cobol [message #615821 is a reply to message #615819] Mon, 09 June 2014 10:56 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
From Oracle documentation :
Quote:

What is Pro*COBOL?

To access an Oracle database, you use a high-level query language called Structured Query Language (SQL). You often use SQL through an interactive interface, such as SQL*Plus.

Pro*COBOL is a programming tool that enables you to embed SQL statements in a COBOL program. The Pro*COBOL precompiler converts the SQL statements in the COBOL program into standard Oracle run-time library calls. The generated output file can then be compiled, linked, and run in the usual manner.

Use the Pro*COBOL precompiler when rapid development and compatibility with other systems are your priorities.

Read more here

http://docs.oracle.com/cd/B10501_01/win.920/a96113/intro.htm

Note : The link explicitly talks about Windows OS.

Re: Pro * Cobol [message #615823 is a reply to message #615821] Mon, 09 June 2014 11:18 Go to previous messageGo to next message
apru
Messages: 4
Registered: June 2014
Junior Member
Thanks lalit

I wanted to know if I will be able to access oracle DB from Z/os batch environment using Pro*cobol.I did not get accurate information from any source regarding this.
Re: Pro * Cobol [message #615824 is a reply to message #615823] Mon, 09 June 2014 12:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

If a Pro*Cobol compiler exists for z/OS then the answer is yes.

Re: Pro * Cobol [message #615846 is a reply to message #615824] Mon, 09 June 2014 20:24 Go to previous messageGo to next message
apru
Messages: 4
Registered: June 2014
Junior Member
Thanks Michel for the clarification. So can we say that it is possible to access oracle database on a distibuted environment from z/os batch environment using pro*cobol precompiler?
Re: Pro * Cobol [message #615889 is a reply to message #615819] Tue, 10 June 2014 10:52 Go to previous messageGo to next message
apru
Messages: 4
Registered: June 2014
Junior Member
Hi

I just want to know whether ORACLE on another platform can be accessed from Z/OS batch environment using PRO*COBOL. Shocked
Re: Pro * Cobol [message #615890 is a reply to message #615889] Tue, 10 June 2014 10:57 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Has anyone suggested this or you just read it somewhere. I see you mentioned in your post that you read it, so what's the source, what else was explained/demonstrated there. Apart from seeking a solution here, where else did you search and what clue did you find?

If you read my above post quoted from documentation, it says the SQL can be embeded in a COBOL program and further steps will get you the result.
Re: Pro * Cobol [message #615892 is a reply to message #615889] Tue, 10 June 2014 11:11 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Michel Cadot wrote on Mon, 09 June 2014 19:27

If a Pro*Cobol compiler exists for z/OS then the answer is yes.

Previous Topic: Oracle On Mac
Next Topic: Connect Z/OS to Oracle on UNIX
Goto Forum:
  


Current Time: Wed Dec 04 01:57:23 CST 2024