Using Extract Files for Updating › Delete Profiles and Authorization from Users › Operand Explanations › Example 2: Removing Group Authorization from Users

Example 2: Removing Group Authorization from Users

An administrator wants to delete a group named SERVGRP from the user records for the company's sales department employees. All of the sales department employees have user IDs that begin with SALES, so the administrator uses the following control statements:

EXTRACT GIVING(SALESEMP) USER AND NO SESSIONS (UIDXNAME(SALES---)) 
DELETE USERMAGN USING(SALESEMP) (SERVGRP)

The EXTRACT statement produces the extract file named SALESEMP, which contains the merged user definition for each user whose user ID begins with SALES. The DELETE statement deletes the user maintenance authorization group named SERVGRP from each user record in the extract file.