Objective: generate a scope report for a user that shows permissions to profiles defined in resource classes that are, according to the CDT, inactive.
This example shows the use of the cross-newlist LOOKUP in a SELECT statement to filter the output of the report.
Notes regarding the CARLa code.
-
The SUPPRESS statement excludes all general reasons that a user can have access from the scope report. This list of keywords is also generated when using option 2 (Direct permit or connect) in a scope report (option RA.3.4).
-
In the SELECT statement, you use the value of field “class” to find a matching value for field “class” in newlist type CLASS. If a matching class name is found, it checks whether the pertinent class is inactive. If that is the case, you include the permission in the report. When the matching class name is active, that permission is not selected.
-
The output modifier “p” in the SORTLIST statement defines a page break when the value for fields “id” and “name” change. This specification ensures that the pertinent permissions for user ID TOMZEEH are started on a new page.
Continue with Closing remarks
© Copyright IBM Corp. 2012, 2020
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.