Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to connect to Oracle database through COBOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 12, 2011 6:35 pm    Post subject: How to connect to Oracle database through COBOL
Reply with quote

Hi,

Can anyone assist me how my cobol program running on mainframe platform can connect and access to Oracle database connected to different Unix platform?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7989
Location: Bellevue, IA

PostPosted: Tue Jul 12, 2011 7:24 pm    Post subject:
Reply with quote

Consult the Oracle documentation. It will provide complete and explicit instructions on how to do so -- if it is possible.
Back to top
View user's profile Send private message
vinit_infy
Warnings : 1

New User


Joined: 07 Apr 2005
Posts: 56

PostPosted: Tue Jul 12, 2011 7:34 pm    Post subject:
Reply with quote

Thanks Robert,

But i was looking for some short of examples..i really dont have time to dig into documentations.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Tue Jul 12, 2011 7:41 pm    Post subject: Reply to: How to connect to Oracle database through COBOL
Reply with quote

Quote:
i really dont have time to dig into documentations.


what in netherworld makes You think that we should spend time to research things for You and for Your stupid organization!

when advanced techniques are planned it is a standard practice, to save some manager ***, and have a smooth implementation, that a proof of concept take place and the support , based on the proof of concept, define the standards and provide training!

so as You see too much work involved for us to waste time on Your organization bad practices!
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Jul 12, 2011 7:48 pm    Post subject: Reply to: How to connect to Oracle database through COBOL
Reply with quote

There is an Oracle Forum out there, and I've used it in the past for specific technical questions. They're probably better equipped to provide you with some details. Now, from what I understand, last year Oracle announced that it was dropping all support for its products on any of the Z-platforms, so my gut feeling is that it's not possible.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Tue Jul 12, 2011 7:54 pm    Post subject: Reply to: How to connect to Oracle database through COBOL
Reply with quote

well the TS asked about connecting to an ORACLE db on a different platform!

looks anyway that the organization to which the TS belongs has not the slightest idea on how to do it !

most probably they never heard of drda and google ...
a simple search with DB2 ORACLE DRDA returned 43000 hits

but the whole shebang needs quite a bit of work...
the low technicalities of the SQL statement format should be the last of their problem

time to lock the topic in a while, or even delete it completely!
Back to top
View user's profile Send private message
Jose Mateo

Active User


Joined: 29 Oct 2010
Posts: 110
Location: Puerto Rico

PostPosted: Tue Jul 12, 2011 8:07 pm    Post subject:
Reply with quote

Good day!

This would be a system programmer task and there's no short example for this kind of task. First you would need a subsystem in the mainframe to connect to your unix system which has the database. The subsystem could be a Oracle gateway (if it exist) or a DB2 gateway which which translate SQL command to Oracle commands. Your best bet is to google for information. Good luck!
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7989
Location: Bellevue, IA

PostPosted: Tue Jul 12, 2011 8:36 pm    Post subject:
Reply with quote

Quote:
But i was looking for some short of examples..i really dont have time to dig into documentations.
In that case -- HIRE A CONSULTANT!

You are dealing with the difficulties of connecting one platform to another, plus dealing with application communications, plus dealing with the Oracle API. If YOU don't have time to dig into the documentation, a forum is not an appropriate source of assistance. We are volunteers, answer when / if we can, and likely do not have time to dig into the documentation for you. What you are asking is an extremely advanced and very site-specific function which requires someone who has dug into the documentation to get right.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Jul 12, 2011 9:09 pm    Post subject:
Reply with quote

Also, Google for PRO*COBOL.

A link to start with is here: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96109/toc.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm
This topic is locked: you cannot edit posts or make replies. COBOL Software Development Lead at Fi... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:21 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us