accessing remote Oracle DB from OS/390 [message #113915] |
Fri, 16 May 2003 13:24 |
Peter Vander Woude
Messages: 2 Registered: January 2001
|
Junior Member |
|
|
If we want to have jobs running under OS/390 directly accessing an Oracle DB on another box, do I have to have Oracle installed on the mainframe. Or is there some "stub" program(s) that can be on the OS/390 system to provide ODBC access to the remote Oracle instance.
Thanks,
Pete
|
|
|
Re: accessing remote Oracle DB from OS/390 [message #113919 is a reply to message #113915] |
Wed, 11 June 2003 11:00 |
Jim Gillespie
Messages: 23 Registered: January 2001
|
Junior Member |
|
|
: If we want to have jobs running under OS/390 directly accessing an Oracle DB on another box, do I have to have Oracle installed on the mainframe. Or is there some "stub" program(s) that can be on the OS/390 system to provide ODBC access to the remote Oracle instance.
: Thanks,
: Pete
I could be wring but I would think you just need TNS(SQLNET) running and a valid tnsnames file in the jcl or proc that has the proper descriptors to get you to the remote db.
Jim Gillespie
|
|
|