Using Extract Files for Updating › Delete Users, Profiles, and Sessions › Operand Explanations › Example 2: Deleting User Sessions

Example 2: Deleting User Sessions

You can use the DELETE statement with an extract file to delete one or more sessions from a set of user records. For example, an administrator wants to delete a session with a session ID of TSO24 from all of the user records that have the session. The administrator uses the following control statements:

EXTRACT GIVING(TSOUSRS) USER AND MATCHING SESSIONS (UENTUSER(TSO24)) 
DELETE USERSESSION USING(TSOUSRS)

The EXTRACT statement produces the extract file named TSOUSRS, which contains the merged user definition and the TSO24 session record for each user who has a TSO24 session defined. Records for the users' other sessions are not included in the extract file. The DELETE statement deletes the user session records that appear in the extract file named TSOUSRS (all TSO24 sessions).