Previous Topic: Example 1: Extracting a List of Users and Their SessionsNext Topic: Example 3: Extracting a List of Profiles and Their Associated Sessions

Extracting Data › Specify Variables Without Assigned Values › Example 2: Extracting a List of Users Using a Particular Session

Example 2: Extracting a List of Users Using a Particular Session

An administrator has written an ACL/E startup program for a session named SALESREP, and wants a report listing all users who have the SALESREP session. The administrator executes the following statement in a batch job:

EXTRACT GIVING(SRUSERS) USER AND MATCHING SESSIONS (UENTUSER(SALESREP))

The statement produces an extract file named SRUSERS that contains the user definition and the SALESREP session record for each user who has the SALESREP session.