Managing Your Query Library Table › Performing Query Table Maintenance (DQLIBRMT) › Utility Report Control Statements › REPORT Control Statement

REPORT Control Statement

Format each REPORT control statement as follows:

1-10

Identifies the type of control statement. The only valid entry is REPORT. Left justify the value with trailing blanks as necessary.

11-72

Specifies the option keywords and their values. You can enter the options in any order. (Available options are listed below.)

Use one of the following formats:

            ┌──────────────────────────────────────────────────┐
►►─ REPORT ─▼─ TITLE=DIRECTORY<,option=value><,option=value>, ─┴──────────────►◄
            ┌──────────────────────────────────────────────────┐
►►─ REPORT ─▼─ TITLE=QUERYTEXT<,option=value><,option=value>, ─┴──────────────►◄

There are no spaces in the keyword portion of the statement. An equal sign (=) separates an option type from its value, and a comma separates the options. Do not enter options past column 72. Following is an example:

 ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+
 REPORT    TITLE=QUERYTEXT,GROUPS=ALL,STATUS=PUBLIC

Required Keyword

TITLE=

Designates which type of report is being requested. This option is required on REPORT statements.

Valid Entries:

DIRECTORY (for a statistics report on the queries owned by each user)

QUERYTEXT (for a report on the text of each query)

Default Value:

(No default)

Optional Keywords

GROUPS=

Designates the hierarchical groups that the user can be assigned to. The order must be Group Level 1, Group Level 2, Group Level 3.

Valid Entries:

A 1- to 15-character group name

Default Value:

ALL

STATUS=

Designates which type of queries are to be processed. This option can appear on REPORT, BACKUP and RESTORE statements.

Note: If QRYGRPS=YES, the STATUS= option is ignored if the USER control statement is used, and only members marked PRIVATE are accessed.

Valid Entries:

PRIVATE, PUBLIC, or ALL

Default Value:

ALL

TYPE=

Specifies the type of Query Library Table member to be processed by the maintenance function.

Valid Entries:

TERM, SQL, SQLD, QUERY, DIALOG, PROC, REPORT, ALL, or JCL (for BACKUP, RESTORE, and REMOVE)

Default Value:

ALL