On 4 Jun 2009 08:27:53 -0700, [email protected] (Patrick Lyon) wrote:
>A DBA wants to know if there is a way to request the execution of an
oracle
>stored procedure on another server from the mainframe and have the result
>return to the mainframe.
If you install the Oracle client libraries on z/OS, you can do this
from SQL*Plus (interactive SQL tool) running as a batch job, TSO
command, or UNIX System Services command. It requires that
the system hosting the Oracle database be reachable from z/OS
via TCP/IP.
/b
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
