DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Condition/Restriction Reporting (DQCRRPT) › Condition Reports

Condition Reports

►►─ REPORT ─ TITLE=CONDITION ─┬───────────────────────────┬───────────────────►
                              └─ ,TABLE= ─┬─ tablename ─┬─┘
                                          └─ ALL ◄ ─────┘

 ►─┬────────────────────────────┬─┬─────────────────────────────────┬─────────►◄
   └─ ,RESTRICTIONS= ─┬─ YES ─┬─┘ └─ CONDITION NAME=condition name ─┘
                      └─ NO ──┘

REPORT Statement

The condition REPORT statement follows the SIGNON statement in the job stream. The control statement REPORT is formatted 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:

TITLE=

Specifies the type of report to be executed.

Valid Entries: CONDITION

Default Value: (No default)

,TABLE=

Specifies the name of the table for which conditions are to be reported (or ALL to report conditions for all tables).

Valid Entries: A 1- to 32-character table name or ALL

Default Value: ALL

,RESTRICTIONS=

Specifies whether you want to have the restrictions reported for each condition.

Valid Entries: YES or NO

Default Value: NO

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. Left justify the value with trailing blanks as necessary.

CONDITION Statement

If specified, the CONDITION statement follows the REPORT statement in the job stream. Unless a CONDITION statement is coded, all conditions are reported. Any table named on REPORT statement applies to the CONDITION statements that follow. The CONDITION statement is formatted as follows:

1-10

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

11-72

Specifies the optional keywords and values. The NAME= keyword is required if a condition statement is coded.

NAME=

Specifies the name of the condition to be reported.

Valid Entries: A 1- to 15-character condition name

Default Value: (No default)

Note: You can request multiple reports that list single conditions by using the NAME= statement.