Reporting 4GL database activity

To retrieve and process the fourth-generation language (4GL) database activity collected in the CMRDETL data sets, use PRL and JCL DD statements to specify the input for your reports.

Related topic

PRL-programming-techniques

The databases and 4GLs are identified by the following field names used in PRL statements:

  • T6EPGNM specifies the program name of any 4GL or database (except MANTIS, which is identified through T6EMNTIS) represented by T6EPTYPE.
  • T6EPTYPE specifies the program name type identified by a 1-character database or 4GL designation.
  • T6EFI specifies the file type identified by a 1-character file or database name represented by T6EFN.
  • T6EFN specifies the file or database name.

For example, the statements shown in the following figure, submitted as an MVS batch job, report on Software AG Natural performance on a given day.

NATURAL performance PRL statements

SET TITLE = 'NATURAL RESPONSE TIMES'
  SET TITLE1 = 'On 09/17/1999'

    SELECT TYPE 6E RECORDS FROM CMRDETL
        WHERE CMRDATE = '09/17/1999'
        AND T6EPTYPE = 'N'

  USING CMRTIME  -
        T6EPGNM  -
        T6EUSER  -
        T6ERESP  -
        T6EFCNT

    REPORT

    END

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*