Previous Topic: CSV Configuration FileNext Topic: PDF Configuration File


CSV Configuration File and Output File Example

The following example shows two reports in the primary report file, the relevant CSV configuration file lines, and the CSV converted output file lines:

CA                REPORT 6 - ERROR MESSAGES                                PAGE 10
CA JCLCHECK    JOB: CAUSER01  PGMR: CAUSER1   WEDNESDAY JANUARY 31, xxxx  2:35:51 AM
--------------------------------------------------------------------------------
  STMT	MESSAGE
  NUM	NUMBER  MESSAGE TEXT
-------------------------------------------------------------------------------

   4.	CAY6077W  NO '3390' UNITS ARE AVAILABLE FOR 'TSU014'
  41.	CAY6092W  JOBLIB/STEPLIB NOT REQUIRED FOR PROGRAM 'XDCCALL'
  43.	CAY6077W  NO '3390' UNITS ARE AVAILABLE FOR 'TSU045'
  44.	CAY6077W  NO '3390' UNITS ARE AVAILABLE FOR 'TSU007'
  55.	CAY6077W  NO '3390' UNITS ARE AVAILABLE FOR 'MVCA11'
CAY6000 5 STATEMENTS FLAGGED IN JOB 'CAUSER01' MAXIMUM SEVERITY WAS 4
*******************************************************************************
CA                 REPORT 7 - SUMMARY DATA SET CROSS REFERENCE                  PAGE 1
CA JCLCHECK                                  WEDNESDAY JANUARY 31, xxxx     2:35:51 AM
----------------------------------------------------------------------------------------
			     DSET  DCB INFO          REFERENCED  IN
DSNAME       SPACE   VOL(S)  TYPE  FMT  LRECL, BLK  JOB (STATUS)    - STEP   (STMT)
-------------------------------------------------------------------------------------
SYS1.PROCLIB          MVCA11  PDS   F 80, 3120  TESSE01J - CHECKJCL.SYSPROC (55)
TESSE01.CSV016        WRKD10                  TESSE01J ( DEFN, CATLG, DELETE) - MODELETE. DD1 (37)
TESSE01.CSV016        WRKD10                     TESSE01J ( DEFN, CATLG)  -  CHECKJCL.JCKCSVO (47)
TESSE01.ISPF.ISPPROF >TSU007  PDS   F 80, 3120   TESSE01J - CHECKJCL.ISPPROF (44)
TESSE01.JCK.CNTL     >TSU014   PDS   F 80, 27920  TESSE01J - PROCLIB (4) CALLDMY1.DMYSTEP1.IN11 (11)
						  CALLDMY1.DMYSTEP1.IN12 (12)
						  CALLDMY1.DMYSTEP1.IN13 (13)
						  CALLDMY2.DMYSTEP2.IN21 (18)
						  CALLDMY2.DMYSTEP2.IN22 (19)
						  CALLDMY2.DMYSTEP2.IN23 (20)
						  CALLDMY3.DMYSTEP3.IN31 (25)
						  CALLDMY3.DMYSTEP3.IN32 (26)
						  CALLDMY3.DMYSTEP3.IN33 (27)
						  CALLDMY4.DMYSTEP4.IN41 (32)
						  CALLDMY4.DMYSTEP4.IN42 (33)
						  CALLDMY4.DMYSTEP4.IN43 (34) CHECKJCL.JCKCSVC (46)
							CHECKJCL.JCKPDFC (49) CHECKJCL.SYSIN (54)
TESSE01.JCK.LOAD    >TSU045  PDS   U, 6144        TESSE01J - CHECKJCL.STEPLIB (43)
TESSE01.PDF016       WRKD10                         TESSE01J (DEFN,CATLG,DELETE) - MODELETE.DD3 (39)
TESSE01.PDF016       WRKD10                       TESSE01J (DEFN,CATLG) - CHECKJCL.JCKPDFO (50)
TESSE01.PRT016       WRKD10                         TESSE01J (DEFN,CATLG,DELETE) - MODELETE.DD2 (38)
TESSE01.PRT016       WRKD10          F 133        TESSE01J (DEFN,CATLG) - CHECKJCL.SYSPRINT (57)
*******************************************************************************************

The CSV configuration file segment shown below consists of a heading template pair for each report, followed by skip template pairs for the hyphen line, title lines, and asterisk lines for each report. In report 6, there is an asis template pair for the CAY6000 information message. The last template pair for both reports are catch-all, default comma template pairs for the main information in each report. This means that any line in report 6 or report 7 which does not match any template pair until this default comma template pair, will be comma-delimited as specified in this default comma template pair.

* THE FOLLOWING ARE THE CONFIGURATION FILE TEMPLATE PAIRS FOR REPORT 6
*--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0
'CA                                   REPORT 6 - ERROR'
HEAD 6
'-------------------------------------------------------------------'
SKIP 1
' STMT MESSAGE'
SKIP 1
' NUM NUMBER MESSAGE TEXT'
SKIP 1
'CAY6000'
ASIS 1
'********************************************************************'
SKIP 1
''
COMMA 1,9,18,132
* THE FOLLOWING ARE THE CONFIGURATION FILE TEMPLATE PAIRS FOR REPORT 7
*--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0--5--0
'CA                                     REPORT 7 - SUMMARY'
HEAD 6
'-------------------------------------------------------------------'
SKIP 1
'                                                    DSET      DCB'
SKIP 1
'DSNAME                           SPACE    VOL(S)    TYPE     FMT LRECL'
SKIP 1
'**********************************************************************'
SKIP 1
''
COMMA 1,44,53,58,73,132

The converted output file segment displayed below shows the results of applying the template pairs above. The first line of each report is the heading line. The heading line is always reformatted and copied to the converted output file in this way. The report name, job and programmer name (if present), and the date and time is comma-delimited and placed as the first line of each report. Following the heading lines on each report is the comma-delimited main data section of each report with commas between the columns specified in the template pairs shown above. The CAY6000 line in report 6 is the result of the asis template pair.

"REPORT 6 - ERROR MESSAGES","JOB: TESSE01J","PGMR: TESSLER","WEDNESDAY JANUARY 31, xxxx 2:35:51 AM"
"4.","CAY6077W","NO '3390'  UNITS ARE AVAILABLE FOR 'TSU014'"
"41.","CAY6092W","JOBLIB/STEPLIB NOT REQUIRED FOR PROGRAM 'XDCCALL'"
"43.","CAY6077W","NO '3390'  UNITS ARE AVAILABLE FOR 'TSU045'"
"44.","CAY6077W","NO '3390'  UNITS ARE AVAILABLE FOR 'TSU007'"
"55.","CAY6077W","NO '3390'  UNITS ARE AVAILABLE FOR 'MVCA11'"
"CAY6000 5 STATEMENTS FLAGGED IN JOB 'TESSE01J' MAXIMUM SEVERITY WAS 4"

"REPORT 7 - SUMMARY DATA SET CROSS REFERENCE","WEDNESDAY JANUARY 31, xxxx            2:35:51 AM"
"SYS1.PROCLIB","MVCA11","PDS","F 80, 3120","TESSE01J - CHECKJCL.SYSPROC (55)"
"TESSE01.CSV016","WRKD10",,,"TESSE01J  (DEFN,CATLG,DELETE)  -  MODELETE.DD1 (37)"
"TESSE01.CSV016","WRKD10",,,"TESSE01J  (DEFN,CATLG)  -  CHECKJCL.JCKCSVO (47)"
"TESSE01.ISPF.ISPPROF",">TSU007","PDS","F 80, 3120","TESSE01J  -  CHECKJCL.ISPPROF (44)"
"TESSE01.JCK.CNTL",">TSU014","PDS","F 80, 27920","TESSE01J-PROCLIB(4)CALLDMY1.DMYSTEP1.IN11(11)"
,,,,"CALLDMY1.DMYSTEP1.IN12 (12)"
,,,,"CALLDMY1.DMYSTEP1.IN13 (13)"
,,,,"CALLDMY2.DMYSTEP2.IN21 (18)"
,,,,"CALLDMY2.DMYSTEP2.IN22 (19)"
,,,,"CALLDMY2.DMYSTEP2.IN23 (20)"
,,,,"CALLDMY3.DMYSTEP3.IN31 (25)"
,,,,"CALLDMY3.DMYSTEP3.IN32 (26)"
,,,,"CALLDMY3.DMYSTEP3.IN33 (27)"
,,,,"CALLDMY4.DMYSTEP4.IN41 (32)"
,,,,"CALLDMY4.DMYSTEP4.IN42 (33)"
,,,,"CALLDMY4.DMYSTEP4.IN43 (34) CHECKJCL.JCKCSVC (46)"
,,,,"CHECKJCL.JCKPDFC (49)  CHECKJCL.SYSIN (54)"
"TESSE01.JCK.LOAD",">TSU045","PDS","U, 6144","TESSE01J - CHECKJCL.STEPLIB (43)"
"TESSE01.PDF016","WRKD10",,,"TESSE01J  (DEFN,CATLG,DELETE) - MODELETE.DD3 (39)"
"TESSE01.PDF016","WRKD10",,,"TESSE01J  (DEFN,CATLG) - CHECKJCL.JCKPDFO (50)"
"TESSE01.PRT016","WRKD10",,,"TESSE01J  (DEFN,CATLG,DELETE) - MODELETE.DD2 (38)"
"TESSE01.PRT016","WRKD10",,"F 133","TESSE01J  (DEFN,CATLG) - CHECKJCL.SYSPRINT (57)"