Home » SQL & PL/SQL » Client Tools » Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2)
Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2) [message #431927] Fri, 20 November 2009 02:08 Go to next message
Nau
Messages: 24
Registered: October 2004
Junior Member
I have a doubt about connection between two systems.

System1: Z/OS mainframe, Cobol/DB2.
System2: AIX server, Oracle 9i

In system1 I need data from system2 (Oracle database). I need data from three tables (three sql's) one of the table has 5 millions records, and my sql will ask for 1 million (aprox). I'm thinking in using a Oracle client installed in system1 (Z/OS) which will connect with Oracle server sin system2. Is that possible???,I have never done anything similar, is there any disadvantage in this architecture??, other options??. My other option is changing flat files with the data between the two systems. I don't like very much, because the applications may grow and need more data, and that will mean more files...

Any help, advice, will be greatly appreciated.
Thanks in advance
Re: Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2) [message #432010 is a reply to message #431927] Fri, 20 November 2009 06:48 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look at this
Previous Topic: Generating Header and Footer information in a Report
Next Topic: To identify SYSTEM user password
Goto Forum:
  


Current Time: Sun Dec 11 04:12:01 CST 2016

Total time taken to generate the page: 0.07504 seconds