Objective: generate a report of profiles in the general resource class XFACILIT including some settings for class XFACILIT from the CDT.
This example shows how you can use the cross-newlist LOOKUP function to retrieve information that is stored in a different newlist type. The cross-newlist LOOKUP function is currently supported for newlist types SYSTEM and CLASS.
-
LOOKUP to newlist type=SYSTEM fields from the newlist types: ACCESS, CONSOLE, DYNEXIT, EXIT, IP_*, MOUNT, PPT, REPORT_AC1, REPORT_PADS, REPORT_STC, RRSF, SENSDSN, SMF, TRUSTED, and UNIX.
-
LOOKUP to newlist type=CLASS fields from the newlist types: ACCESS, CICS_*, DB2_*, IMS_*, IP_PORT, IP_NETACCESS, IP_VIPARACF, RACF_ACCESS, SMF, SAFRFR, REPORT_PROFILE, REPORT_SCOPE, and TRUSTED.
In the following CARLa program, LOOKUPs to newlist type SYSTEM fields from newlist type CONSOLE is illustrated.
Notes regarding the CARLa code.
-
In the NEWLIST statement, the TOPTITLE (TT) is started and completed by the system name by the system(tt) specification in the SORTLIST statement.
-
The report shows that the EMCS and MCS consoles are filtered by the SELECT statement.
-
The report TITLE is started by the literal that starts with “Console” and ends with “member:” in the SORTLIST statement. The cross-newlist LOOKUP is used to retrieve the parmlib member name. This LOOKUP takes the value of field “system” in newlist CONSOLE and matches that value against the field “system” in newlist SYSTEM. If a matching system name is found, then the value of field “con_consol” is printed at the end of this TITLE.
-
Next, the cross-newlist LOOKUP function is used 2 times more to retrieve the fields “con_logon_auto” and “con_logon_req”. Together with some more literals these values complete the report TITLE.
-
The output modifiers “TT” and “T” used in the SORTLIST redirect the output to the TOPTITLE and TITLE instead of in the report.
This screen capture shows what the output of this CARLa program might look like:
Exercise:
Use the cross-newlist LOOKUP function to produce the following report. Show all profiles that are defined in the general resource class XFACILIT with the following layout specification:
-
The top title of the report must state “Profiles defined in the XFACILIT class”.
-
The title must start with “XFACILIT class settings from CDT ->”
-
Then this report title must be completed with the CDT class settings for XFACILIT class that indicate:
o The default return code (dfltrc).
o Whether the class is active (active).
o The logoptions setting (logopt).
o The audit setting (audit).
The appropriate field names in the CLASS newlist are shown in parentheses ().
-
The report must contain the columns: profile key, owner, universal access, and ACL.
View Suggested samples and answers
Continue with Lookup across NEWLISTs
© 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.