Extracting Data › Specify Variables Without Assigned Values › Example 4: Extracting a List of Profiles with a Particular Session

Example 4: Extracting a List of Profiles with a Particular Session

An administrator wants to know what profiles have a session with a session ID of TSO2. The administrator also wants the report to list the startup and termination ACL/E programs that are assigned for the session by each profile. The administrator executes the following statement in a batch job:

EXTRACT GIVING(TSO2PROF) PROFILE AND MATCHING SESSIONS (PENTUSER(TSO2))

The statement produces an extract file named TSO2PROF that contains the profile definition and TSO2 session records for each profile that has a session with a session ID of TSO2.

Note: The records for sessions other than TSO2 are not included in the extract file.