What is the process to generate a report with ACT table entries in Batch?
Release:
Component: TPX
To print the ACT entries for an ACT table named ACTSWD, the following batch report can be used: (release 5.3 and above)
//SYSIN DD * EXTRACT GIVING(EXTFILE) ACT (VACTTBL(ACTSWD)) REPORT GIVING(RPTFILE) USING (EXTFILE) ((' &ACTNAME' ' &ACTLABEL ' ' &ACTSESS' ' &VACTTBL'))
Example output of the report above:
ACTNAME ACTLABEL ACTSESS VACTTBL
=====================================================
A01ITSO TSO1 Label TSO1 ACTSWD
A11ITSO CA11 TSO CA11 ACTSWD
A29ISTAR STAR STAR ACTSWD
A31ITSO CA31 TSO CA31 ACTSWD
A58IVM DE29 Mini MVSDE29 ACTSWD
A61ITSO XE61 TSO XE61 ACTSWD
TPXADMIN TPX Administratio ACTSWD
TPXDEMO TPX Dummy Session ACTSWD
Example extract statement for only Applids (ACTNAME) starting with 'TP':
EXTRACT GIVING(EXTFILE) ACT (VACTTBL(ACTSWD) ACTNAME(TP------))
Multiple fields can be entered, make sure they are enclosed in the parenthesis.
The report would only show TPXADMIN and TPXDEMO.
More detail on Batch Administration/Reporting can be found under the section : Batch Administration .
There is also an area 'BATCH Variables' which has detail on User, Profile and Application variables that can be used in reports.
The above example uses Application Variables.
Sample Batch Reporting jobs are in hilvl.CB0VSRC, they start with 'BR'.