Penn State mark   AIS Header AIS Home Page link ITS Home Page link
in:
AIS Home > Data Warehouse > Data Warehouse Database Developers > Sample JCL

Sample JCL



FTP Steps
Below is sample JCL that will need to be added to your JCL to FTP the information to the Warehouse.  Any information proceeded with an asterisk(*) needs to be obtained by sending an e-mail to datawarehouse@psu.edu.

For ISIS Related Jobs –

//JS10     EXEC PFTP

//PS10.INPUT  DD DSN=PERM.MAINTJCL(DW1FTP),

//         DISP=(SHR,KEEP,KEEP)

//         DD *

CD\*yourdirectoryname. 

PUT 'Name of dataset you created(0)'   *yourdatafilename.dat

PUT 'PROC.SOURCE(FTPEND)'   yourjclname.END

 

For IBIS Related Jobs –

//JS10     EXEC PFTP

//PS10.INPUT  DD DSN=PERM.MAINTJCL(DW2FTP),

//         DISP=(SHR,KEEP,KEEP)

//         DD *

CD\*yourdirectoryname. 

PUT 'Name of dataset you created(0)'   *yourdatafilename.dat

PUT 'PROC.SOURCE(FTPEND)'    yourjclname.END

 

Creating your CA7Agent Update Job
Production Control now requires a second JCL job be developed that will allow for the update process on the warehouse through CA7Agent. 

  • You’ll need to request a new procedure name by using the RPF.  The first 2 characters of the JCL name should be your areas standard procedure letters followed by XP.  Take the next available number. A template for this JCL can be found at XL.CA7Agent and an example of one already in production is ZI.FZXP001.
  • You’ll need to request a input parm number.  This can be done by sending an e-mail to datawarehouse@psu.edu. This parm number will then be entered into your JCL.




Questions: Data Warehouse


Printer friendly view



The Pennsylvania State University © 2008 | Copyright | Privacy and Legal Statements | Alternative Media - Nondiscrimination Statement
This site is maintained by Administrative Information Services, a unit of Information Technology Services.
Provide site feedback to AIS-webmaster@psu.edu. Can't find it? Ask AIS
Last revised: Friday, September 28, 2007 8:57