Previous Topic: DELETE StatementNext Topic: Securing Data Access for DQL Use


REPORT Statement

The REPORT control statement follows the SIGN/ON statement in the job stream. The REPORT control statement is formatted as follows:

Columns 1-10

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

Columns 11-72

Specifies the option keyword and its value, as described next.

►►─ REPORT ─┬─ USER= ────────────────────────────────────────────────┬────────►◄
            ├─┬─ userid ─┬───────────────────────────────────────────┤
            │ └─ *ALL* ──┘                                           │
            └─ GROUP1=value ─┬─────────────────────────────────────┬─┘
                             └─ ,GROUP2=value ─┬─────────────────┬─┘
                                               └─ ,GROUP3=value ─┘
USER=

Specifies the user ID of the person whose authorizations are to be reported. To report the authorizations for every user defined to the system, code USER=*ALL*.

Valid Entries:

A 1- to 32-character user ID or *ALL*

Default Value:

(No default)

GROUP1=, GROUP2=, and GROUP3=

Specifies the group ID of the group whose authorizations are to be reported. If you specify GROUP3=, you must also specify GROUP2=. If you specify GROUP2=, you must also specify GROUP1=.

Valid Entries:

A 1- to 32-character group ID

Default Value:

(No default)