Extracting Data › Specify Variables Without Assigned Values › Example 1: Extracting a List of Users and Their Sessions

Example 1: Extracting a List of Users and Their Sessions

An administrator wants a report that lists the sessions that the company's service department employees use. The administrator also wants to know what startup and termination ACL programs the users have assigned for their sessions. The user IDs for service department personnel begin with SERV, followed by a four-character code unique to the user. The administrator issues the following statement in a batch job:

EXTRACT GIVING(SERVSESS) USER AND ALL SESSIONS (UIDXNAME(SERV----))

The EXTRACT statement produces an extract file named SERVSESS that contains the merged user definitions and the associated session records for each user whose user ID begins with SERV.