Re: Oracle on MVS able to submit JCL ??

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 <ORACLE-L_at_fatcity.com> 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: babette_at_rogers.com
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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).