Condition/Restriction Reporting (DQCRRPT)

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

Condition/Restriction Reporting (DQCRRPT)

If you have condition/restriction authorization specified on the Administrative Menu you can request Condition/Restriction reports using the DQCRRPT utility. A Status Report is printed at the end of the report that indicates if the request was successful or if an error was found in the request.

Condition reports print the following for each condition:
- The name of the condition
- The table name
- The text of the condition
- A list of the restrictions in which the condition appears
Restriction reports print the following for each restriction:
- The name of the restriction
- The user or group to which the restriction applies
- A list of all conditions within the restriction
- The text of each condition

Action

Use the report control statements to identify the functions performed by DQCRRPT. A maximum of 60 report and maintenance control statements is allowed. There are five types of report control statements:

SIGN/ON: (Required) Specifies the user ID and password. Only one SIGN/ON statement is allowed and it must be the first statement in the job stream.
REPORT: (Required) Specifies the title of the report to be produced with this run, and the Restrictions and the Table name to be reported.
CONDITION: (Optional) Specifies the Condition name for the report to be produced with this run.
USER: (Optional) Specifies the userid for the report to be produced.
GROUP: (Optional) Selects the group for the report to be produced.