Previous Topic

Next Topic

Book Contents

Book Index

CTTRPT – Database extraction and report utility

The CTTRPT utility extracts data from the Media database (MDB) using Extract parameters and generates reports from the extracted data using Report Formatting parameters.

Data extraction and report generation are performed in a single utility run. Both Extraction parameters and Report Formatting parameters are specified in the utility run.

Instead of extracting entire records, the utility only extracts information required for the report from the Media database (or from the extracted data set described above) and produces the report. There is no need to create a data set for saving the extracted information, although this can be done if desired.

This method of report generation is the most efficient when a single report is required.

It is also most efficient when all the data requirements of subsequent reports can be satisfied from the extracted data (meaning, when no additional data is required by subsequent reports). In this case, the extracted data is saved in a data set for subsequent runs of the utility.

At least one group of parameters must be specified, such as Extract parameters or Report Formatting parameters.

The data set for holding extracted information is specified in DD statement REPDATA.

Parent Topic

Control-M/Tape Utilities