How can the entries of an ACT table be printed in batch TPX?

Products

• TPX - Session Management

Issue/Introduction

What is the process to generate a report with ACT table entries in Batch?

Environment

Release:
Component: TPX

Resolution

 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.

Additional Information

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'.