IDMS Set Activity Report (DREPORT 027)

Standard Dictionary Reports—DREPORTS › Cross-Reference Reports › IDMS Set Activity Report (DREPORT 027)

IDMS Set Activity Report (DREPORT 027)

Contents

The IDMS Set Activity report provides information about how programs reference sets. These set/program relationships are defined through the SET clause of the DDDL PROGRAM statement or through the DML processors if the activity log is on and the dictionary is in UPDATE mode at run time.

Sample DREPORT 027:

REPORT NO. 27 DATA DICTIONARY REPORTER REL nn.n mm/dd/yy PAGE 1 DREPORT 027 IDMS SET ACTIVITY REPORT ********************************************************************************************************************************* ---- D A T E ---- SCHEMA VER SUBSCHEMA SET PROGRAM VER USAGE TIMES COMPILED CREATED ********************************************************************************************************************************* EMPSCHM 1 EMPSS01 DEPT-EMPLOYEE NRDY99D 1 OBTAIN 1 mm/dd/yy mm/dd/yy EMPSCHM 1 EMPSS01 DEPT-EMPLOYEE NRDY97D 1 OBTAIN 1 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 CALC CBDML01 1 OBTAIN 1 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 CALC CBDML03 1 FIND 1 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 CALC CBDML03 1 FIND 5 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 CALC CBDML03 1 OBTAIN 1 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 CALC CBDML03 1 OBTAIN 4 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 DEPT-EMPLOYEE MCMT03D 1 FIND 1 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 DEPT-EMPLOYEE MCMT03D 1 IF 4 mm/dd/yy mm/dd/yy EMPSCHM 100 EMPSS01 DEPT-EMPLOYEE MCMT04D 1 FIND 1 mm/dd/yy mm/dd/yy

Field Descriptions

A description of the fields in the sample report follows:

SCHEMA/VER: Identifies the name and version number of a schema that contains a set referenced by a program.
SUBSCHEMA: Identifies the name of the subschema in which the set exists.
SET: Identifies the name of a set associated with a program.
PROGRAM/VER: Identifies the name and version number of the program using this set.
USAGE: Identifies the DML command issued against this set by the named program.
TIMES: Indicates the number of times this DML command is issued against the set within the named program.
DATE COMPILED/CREATED: Identifies the date the program was last compiled and the date the program occurrence was defined to the dictionary.