Extracting Data › Specify Variables Without Assigned Values › Example 3: Extracting a List of Profiles and Their Associated Sessions

Example 3: Extracting a List of Profiles and Their Associated Sessions

An administrator wants a report listing the profiles that are set up to give the user PASS access to the sessions. The administrator also wants to know what sessions are associated with the profiles. The administrator executes the following statement in a batch job:

EXTRACT GIVING(PASSPROF) PROFILE AND ALL SESSIONS (PIDXACCS(PASS))

The EXTRACT statement produces an extract file named PASSPROF that contains the profile definition and associated session records for each profile that has a value of PASS in the ACCESS field.