|
View previous topic :: View next topic
|
| Author |
Message |
vinit_infy
Warnings : 1
New User
Joined: 07 Apr 2005
Posts: 56
|
|
|
|
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 |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| Consult the Oracle documentation. It will provide complete and explicit instructions on how to do so -- if it is possible. |
|
| Back to top |
|
|
vinit_infy
Warnings : 1
New User
Joined: 07 Apr 2005
Posts: 56
|
|
|
|
Thanks Robert,
But i was looking for some short of examples..i really dont have time to dig into documentations. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
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 |
|
|
Jose Mateo
Active User
Joined: 29 Oct 2010
Posts: 121
Location: Puerto Rico
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
