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 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. > > -----Original Message----- > Greg > Sent: Monday, November 18, 2002 10:04 AM > To: Multiple recipients of list ORACLE-L > > > 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 Oracle. > > Here is an example using just UNIX: > > HOW TO SUBMIT A MAINFRAME BATCH JOB FROM UNIX > > STEP ONE: Create your jcl in a unix file. remember to use all upper case! > > EXAMPLE: iefbr14.jcl > > file://M33TEST1 JOB (HRP,TEST),M33,CLASS=V,MSGCLASS=X,NOTIFY=M33 > file://STEP01 EXEC PGM=IEFBR14 > file://DD1 DD DSN=M33.TEST.FILE2, > // UNIT=HRSDA, > // SPACE=(CYL,(1,1),RLSE), > // DCB=(RECFM=FB,LRECL=080,BLKSIZE=27920,DSORG=PS), > // DISP=(NEW,CATLG,DELETE) > file://SYSPRINT DD SYSOUT=* > file://SYSOUT DD SYSOUT=* > file://* > > STEP TWO: Create a job script to FTP your JCL to the mainframe. > 192.6.1.79 is the address of the mainframe for this example. > 'uid' should be replaced with your user id. > 'password' should be replaced with your password. > 'iefbr14.jcl' is the file that we created in step one. > Remember to grant execute rights to the job script using chmod. > > ######################################################################## > ### ftp a job to be submitted on the mainframe > ######################################################################## > ftp -vn 192.6.1.79 <<END_OF_FTP_INPUT > user uid password > site filetype=JES > put iefbr14.jcl > bye > > STEP THREE: Run your job (as illustrated by the output). > > $ ftpjesjob.job > Connected to 192.6.1.79. > 220-FTPSRVR IBM MVS V3R2 at IBMMVS01, 12:07:39 on 2000/08/03 > 220 Connection will close if idle for more than 2 minutes. > Remote system type is MVS. > 331 Send password please. > 230 M33 is logged on. Working directory is "M33.". > 200 Site command was accepted > 200 Port request OK. > 125 Sending Job to JES Internal Reader FIXrecfm 80 > 250-It is known to JES as JOB00676 > 250 Transfer completed successfully. > 349 bytes sent in 0.00 seconds (1002.41 Kbytes/s) > 221 Quit command received. Goodbye. > $ > > Hope that helps you out > > Greg > -- > [snipped] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Babette Turner-Underwood > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).