Sample Mainframe JCL and Parameter File
Many thanks to Blair Chesnut and Peggy Forster for providing the
testing and use of this example.
In the following text, a sample JCL job and it's associated
parameter file are given. A user should be able to copy the
pertinant sections of this example and build their own job
from this example.
Sample JCL
000001 //W9401RRR JOB 'NCS.ACS.J9401',FORSTER,MSGLEVEL=1,MSGCLASS=Q,CLASS=N
000002 /*JOBPARM ROOM=#ACS
000003 //*PROCLIB=NCSACS.PROCLIB
001401 //STP1 EXEC PGM=FTP,COND=(0,NE)
001402 //SYSIN DD DISP=SHR,DSN=NCSACS.J9826.MLF.SOURCLIB(Z9401RR1)
001403 //SYSPRINT DD SYSOUT=*
001404 //*
001500 //*STP2 EXEC P9401RRR
001600 //*
001700 //*STP3 EXEC PGM=FTP,COND=(0,NE)
001800 //*SYSIN DD DISP=SHR,DSN=NCSACS.J9826.MLF.SOURCLIB(Z9401RR2)
001900 //*SYSPRINT DD SYSOUT=*
Sample Parameter file for above JCL
Parameter file (Z9401RR1 from SYSIN line 1402 in above JCL):
000001 sybasedev.acs.ncsu.edu 9220 (EXIT=8 TIMEOUT 240
000002 <sybase-userid> <sybase-password>
000003 cd <database-name>
000004 GET <upload_proc> 'P220201.J9401.HOUSE.RS6000.RESIDENT' (REPLACE
000005 CLOSE
000006 QUIT
A few things of note:
- You would need to substitute the appropriate host IP address and
port number in line 000001 of the above parameter file. The hosts
and port numbers are listed in a table on the
SQL-ftpd IP Address List page.
- Depending on your query, you may need to adjust the timeout value
specified on line 000001 of the above parameter file.
- You would need to make the appropriate substitutions for <sybase-userid>,
<sybase-password>, <database-name> and <update_proc>.
The substituted values would depend on your particular job and query. For
queries, always use stored procedures, as exemplified above.
- Obviously you would want to substitute your own dataset name for
P220201.J9401.HOUSE.RS6000.RESIDENT.
Next Step: SQL-ftpd Server IP Address List
Back to the SQL-ftpd Contents Page