Re: Oracle on MVS able to submit JCL ??

2002-11-21 Thread Yechiel Adar
Have you tried to put a DD card for internal reader and write to this DD with utl_file? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 1:49 AM Thanks but EVERYTHING is on the mainframe (including

RE: Oracle on MVS able to submit JCL ??

2002-11-21 Thread Mirsky, Greg
You could FTP to 127.0.0.1 127.0.0.1 is the universal IP address of the system you are on. That is you would FTP to yourself and then send the FTP file, the JCL, to the JES reader. Give it a try it seems to work on our installation. Greg -Original Message- Sent: Wednesday, November

RE: Oracle on MVS able to submit JCL ??

2002-11-20 Thread Babette Turner-Underwood
Thanks but EVERYTHING is on the mainframe (including Oracle). As far as I know there is no such thing as PIPEs and daemon processes on the mainframe. I can place skeleton JCL in a proclib. The problem is getting Oracle on the mainframe to somehome invoke the internal reader to submit the JCL.

RE: Oracle on MVS able to submit JCL ??

2002-11-18 Thread Mirsky, Greg
Babette, If you are on a UNIX platfrom you can ftp the JCL directly to the JES reader to submit a job on the mainframe. You need to set the parameter site filetype=JES. On my web site (http://www.oracle-developer.us/code.htm) I have code posted to allow Oracle 8i or greater to FTP directly from

Re: Oracle on MVS able to submit JCL ??

2002-11-16 Thread Stephane Faroult
Babette Turner-Underwood wrote: Does anyone on this listserv using Oracle on a mainframe? I was asked today if I can use Oracle's extproc feature on the mainframe to submit JCL. I said that I doubted it because the OS structure is so much different than UNIX or NT, but I would look into

Oracle on MVS able to submit JCL ??

2002-11-15 Thread Babette Turner-Underwood
Does anyone on this listserv using Oracle on a mainframe? I was asked today if I can use Oracle's extproc feature on the mainframe to submit JCL. I said that I doubted it because the OS structure is so much different than UNIX or NT, but I would look into it. Has anyone tried to somehow have