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 oracle from mainframe db2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Tue May 30, 2006 4:56 pm    Post subject: How to connect oracle from mainframe db2
Reply with quote

Hi All,

Here my requirement,

I need connect to UNIX server ORACLE database from MVS that has DB2 install by issuing selelct cmd...

Please let me know what all the configurations and settings need to be done......

Thanks in advance,
jai
Back to top
View user's profile Send private message

parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Thu Jun 01, 2006 2:38 pm    Post subject:
Reply with quote

Hi,
I think, there is no direct method of connecting to ORACLE database running on remote host ( from the host in which your program is running).

You might need to have a call to exernal programs (shipped with oracle) to do this or may need to add another steps in precompile, compile bind JCLs so that those calls will be automatically put in your code.

However, you need to have a mechanism in place to differentiate your DB2 code from the ORACLE code in your program.

We used to put the queries for ORACLE datbase in copybooks so that the copybooks are expanded before compilation and after the DB2 precompilation.

Best person to ask is your DBA.

Thanks,
Parikshit
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Thu Jun 01, 2006 4:04 pm    Post subject:
Reply with quote

Thanks Parikshit......

Great that we have got some mechanism to work for the requirement....

Can you please throw more light on the mechanism that you are telling about
''You might need to have a call to exernal programs (shipped with oracle) to do this or may need to add another steps in precompile, compile bind JCLs so that those calls will be automatically put in your code. ''

Can you please let me know more details it would be great for not only me for others in the forum.....because this rare kind of post.....

Requirement :
I need to get the data from the oracle database and using that data i need to update mainframe databse. Depending on the successfull execution of mainframe database then i need to update oracle databse....

i.e select on oracle databse, update mainframe db2, update oracle database

Thanks in advance,
jai
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Admin Openings with CTS enikhilk Mainframe Jobs 0 Tue Sep 13, 2016 10:13 am


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