ESP Workload Automation

When running the ESP report below every page repeats the header information, does anyone know of a good way to strip the header information for each page and also create the report as a csv file?

REPORT
CRITERIA APPLSYS EQ 'FIDR-'
FROM NOW LESS 1 HOUR
DATEFORM DAY(NO) MDY
DISPLAY APPLSYS APPLGEN JOBNAME FULLNAME,30 EXECSDATE EXECST -
ENDDATE ENDT EXECQT AVGRUNT CMPC CCFAIL FORCED
SORT EXECSDATE EXECST
ENDR

Thank you.

Sharon

Hi Sharon, 

The REPORTCV option will create the report in CSV format.  A link to the doc and an example are below.  

https://docops.ca.com/ca-workload-automation-esp-edition/11-4/en/reference/commands/reportcv-command-begin-report-definition-csv-format

REPORTCV
INPUT DATASET('CYB1.TONYT540.HISTFILE')
CRITERIA JOBNAME EQ WAIT5 OR JOBNAME EQ CALC
FROM MAY 1 2004
DISPLAY JOBNAME,JOBNO,APPLSYS,OVDSUBAT,OVDBEGAT,OVDENDAT,OVDEND
SORT EXECSDATE EXECST JOBNAME
ENDR

To remove the headers I add a step after the report step. It runs a very simple piece of REXX that removes the unwanted lines.  Let me know if this is an option for you. I can attach the JCL and REXX here. 

2cents 

Don

Hello Don,

Thank you, this is great I didn't know this was available and if you could attach the JCL and REXX to remove those unwanted lines I would appreciate it.

Thanks again,

Sharon

Hi Sharon, 

When I went to look I found a few versions of the code. This one did what I wanted.  If it doesn't remove some line you have you can probably modify the code. If you have any questions let me know.  

2¢

Don

Hopefully the attachments show up.... 

Thank you again Don, I have the attachments and I'll give this a try.