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

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

book

Article ID: 51575

calendar_today

Updated On:

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