Previous Topic: Define a GDG PDS Data Set (Optional)

Next Topic: Creating CSV Files Using the CA Earl Report Writer


Batch Execution JCL and SORT Statement

Member CAJRCSVJ, found in the CAJRJCL library, is used as an example of the JCL requirements and SORT control statement changes necessary to create CSV files as output from CA JARS.

//CAJRCSVJ JOB (ACCTINFO),'PGMR',CLASS=A,MSGCLASS=X,REGION=0M
//*********************************************************************
//*                                                                   *
//*  MEMBER : CAJRCSVJ IN CAI.CAJRJCL                                 *
//*                                                                   *
//*  PURPOSE: THIS IS  AN EXAMPLE JCL  MEMBER THAT SHOWS THE USER HOW *
//*           TO  CREATE  CSV  FILES  IN A  PDS  USING  THE CA-JARS   *
//*           REPORT WRITER.  THE  CAIJSCSV  AND  CAIJSIDX DD  WHICH  *
//*           DEFINE THE CSV  PDS DATASET AND  THE CSV INDEX DATASET  *
//*           ARE  OF  PARTICULAR  INTEREST.  ALSO,  NOTICE THE SORT  *
//*           CONTROL  STATEMENT  HAS  THE CSV MEMBER NAME SPECIFIED  *
//*           IN COLUMNS 65 THROUGH 72.                               *
//*                                                                   *
//*  MODIFICATIONS:                                                   *
//*                                                                   *
//*  1.  THE INDEX DATASET  MUST EXIST  PRIOR  TO SUBMISSION  OF THIS *
//*      JOB.  PROCESS MEMBER 'CAJRINIT' IN  CAI.CAJRJCL  TO ALLOCATE *
//*      AND  INITIALIZE THE  INDEX DATASET, CAIJSIDX.  REFER TO  THE *
//*      CSV FILE  PRODUCTION  CHAPTER  OF  THE  CA-JARS  r12  USERS  *
//*      GUIDE FOR MORE DETAILED INFORMATION ON THE CREATION OF CSV   *
//*      FILES.                                                       *
//*                                                                   *
//*  2.  CHANGE  ALL REFERENCES TO 'CAI' TO  MATCH YOUR  INSTALLATION *
//*      STANDARDS.                                                   *
//*                                                                   *
//*  3.  ALL  UNIT=SYSDA STATEMENTS  MAY HAVE  TO BE  CHANGED IF YOUR *
//*      INSTALLATION  USES DIFFERENT  ESOTERIC  NAMES FOR  TEMPORARY *
//*      DASD.                                                        *
//*                                                                   *
//*  4.  ALL UNIT=???? AND VOL=SER=XXXXXX HAVE TO BE CHANGED TO MATCH *
//*      YOUR INSTALLATION STANDARDS.                                 *
//*                                                                   *
//*      **NOTE** RETURN CODE SHOULD NOT BE GREATER THAN 4.           *
//*                                                                   *
//*********************************************************************
//JARS      EXEC PGM=JSIMAIN                                           
//STEPLIB   DD DSN=CAI.CAJRLOAD,DISP=SHR               <==CUSTOMIZE    
//CAIJSNAP  DD SYSOUT=*,DCB=(RECFM=VBS,LRECL=125,BLKSIZE=882)                  
//CAIJSPRT  DD SYSOUT=*                                                        
//SYSOUT    DD SYSOUT=*                                                        
//CAIJSC    DD DUMMY                                                           
//CAIJSOUT  DD SYSOUT=*                                                        
//SYSUDUMP  DD SYSOUT=*                                                        
//CAIJSCSV  DD DSN=CAI.CSVPDS.OUTPUT,                <==CUSTOMIZE              
//          DISP=(NEW,CATLG,KEEP),                                             
//          DCB=(RECFM=VB,LRECL=512,BLKSIZE=5124),                             
//          UNIT=????,VOL=SER=XXXXXX,                <==CUSTOMIZE              
//          SPACE=(CYL,(10,5,20)),                                             
//          DSORG=PO                                                           
//CAIJSIDX  DD DSN=CAI.CSVPDS.INDEX,DISP=MOD         <==CUSTOMIZE              
//SORTWK01  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//SORTWK02  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//SORTWK03  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//SORTWK04  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//SORTWK05  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//SORTWK06  DD UNIT=SYSDA,                                                     
//             SPACE=(CYL,(5))                                                 
//CAIJSCT2  DD UNIT=SYSDA,DISP=(,DELETE,DELETE),                               
//             SPACE=(TRK,(10,1))                                              
//CAIJSCT1  DD UNIT=SYSDA,DISP=(,DELETE,DELETE),                               
//             SPACE=(TRK,(10,1))                                              
//CAIJSSMF  DD DSN=CAI.SMF.IMPUT.DATA,DISP=SHR         <==CUSTOMIZE            
//SYSPRINT  DD SYSOUT=*                                                        
//SYSPUNCH  DD SYSOUT=*                                                        
//HISTFILE  DD DSN=CAI.JARS.HISTORY,DISP=OLD         <==CUSTOMIZE              
//CAIJSACT  DD DSN=CAI.JARS.ACCT,DISP=OLD            <==CUSTOMIZE              
//CAIJSCIN  DD *                                                               
 SELECT     1                                     M                     P 3 1 5
 OPTION  0001              ,.                                                  
EXTDATA NYNYYYYYYYYYYYYYYYYYYYYYYYYYNYYY                                
MHEADER  048P E A K   P A G I N G   P E R I O D S                        
MSORT    29701A3                                     S          CSVTST22 
MDISPLAY   0020560A81A90C21C30C81C90D3075040178177142                    
MRATE     1000          100                                              
MTSORATE  1000              100                                          
MTITLE   02                    TIME INTERVAL                             
MTITLE   42PERCENT                 CPU                                   
MTITLE   56   NBR               STEPS                                    
MGROUP   0281 R0372                                                      
MGROUPC  1T                                                              
MGROUPC  200      01      A                                              
MGROUPC  202      03      B                                              
MGROUPC  204      05      C                                              
MGROUPC  206      07      D                                              
MGROUPC  208      09      E                                              
MGROUPC  210      11      F                                              
MGROUPC  212      13      G                                              
MGROUPC  214      15      H                                              
MGROUPC  216      17      I                                              
MGROUPC  218      19      J                                              
MGROUPC  220      21      K                                              
MGROUPC  222      23      L                                              
MDESCRIPT1        UNIDENTIFIED                                           
MDESCRIPT1A       00.00  TO  01.59                                       
MDESCRIPT1B       02.00  TO  03.59                                       
MDESCRIPT1C       04.00  TO  05.59                                       
MDESCRIPT1D       06.00  TO  07.59                                       
MDESCRIPT1E       08.00  TO  09.59                                       
MDESCRIPT1F       10.00  TO  11.59                                       
MDESCRIPT1G       12.00  TO  13.59                                       
MDESCRIPT1H       14.00  TO  15.59                                       
MDESCRIPT1I       16.00  TO  17.59                                       
MDESCRIPT1J       18.00  TO  19.59                                       
MDESCRIPT1K       20.00  TO  21.59                                       
MDESCRIPT1L       22.00  TO  23.59                                       
/*                                                                       
//