Home » Infrastructure » Other Operating Systems » RUNNING BATCH JCL IN THE MAINFRAME ACCESSING ORACLE IN UNIX WITH STORE PROCEDURES
RUNNING BATCH JCL IN THE MAINFRAME ACCESSING ORACLE IN UNIX WITH STORE PROCEDURES [message #113954] Wed, 03 September 2003 09:49 Go to next message
Pablo Campanini
Messages: 13
Registered: January 2001
Junior Member
WE WANT TO RUN A BATCH JCL STRUCTURE IN THE MAINFRAME, THAT WILL EXECUTE STORE PROCEDURES IN A REMOTE UNIX ORACLE DATABASE, IF YOU RUN SOMETHING SIMILAR TO THIS, PLEASE LET US KNOW.

WE WERE RUNNING ORACLE 8.1.7. MPM IN THE MAINFRAME IN A OS/390 VERSION 2.10. THE ORACLE UNIX VERSION COULD BE 8.1.7 OR ORACLE 9.
Re: RUNNING BATCH JCL IN THE MAINFRAME ACCESSING ORACLE IN UNIX WITH STORE PROCEDURES [message #113956 is a reply to message #113954] Thu, 04 September 2003 01:33 Go to previous message
stephen heasley
Messages: 4
Registered: November 2001
Junior Member
As long as you have tcp access from the mainframe to the unix box, then sqlplus should be able to run on the mainframe accessing the remote database, as long as the tnsnames file allocated by the tnsnames dd statement contains the remote db address.
The easiest way to test, is just to use batch sqlplus to connect to the remote database and select * from v$database, to prove you have attached to the correct database. after that its just a case of building in the exec statements for the stored procs.
Previous Topic: Enclaves being left on oracle 9202 (zos 1.4)
Next Topic: Cost based Optimizer built access paths
Goto Forum:
  


Current Time: Sat Dec 05 12:33:55 CST 2020